Answer Posted / raj
for example if we take emp table, the query like this...
select a.sal from emp a where 4=(select count(distinct(b.sal))from emp b where a.sal<=b.sal)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
How do I truncate a word?
How to use sql*plus built-in timers?
what is 'mysqlshow'? : Sql dba
Why do we need pl sql?
What is the advantage of nosql?
Can we use views in stored procedure?
what is a record in a database ? : Sql dba
What is full join?
How do I count rows in sql query?
What are the different ddl commands in sql?
What are the two types of cursors in pl sql?
Why do we need view in sql?
Write a sql query to convert all character to uppercase after hypen.
What is coalesce sql?
What is the sql*loader? : aql loader
