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
How is sql used in oracle?
How do I view stored procedures?
What is nvarchar in sql?
What is sql query limit?
what is bcp? When does it used? : Sql dba
Why do we use partitions in sql?
What is the benefit of foreign key?
Can a table contain multiple foreign key’s?
What are three advantages to using sql?
What is an ndf file?
What is trigger in pl sql?
How many parts of a pl sql block are optional?
What is the difference among union, minus and intersect?
What is thread join () in threading?
What are the different operators available in sql?