Answer Posted / karthik
select distinct sal from emp a where 2 = (select count
(distinct sal) from emp b where a.sal <= b.sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to select some rows from a table in oracle?
What are the various constraints used in oracle?
How can I introduce multiple conditions in like operator?
How to list all indexes in your schema?
What are the benefits of ordbms?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is a cursor variable?
What is hash cluster in oracle?
How to convert characters to dates in oracle?
How to put more than 1000 values into an oracle in clause?
What is a tns file?
How do we display rows from the table without duplicates?
How to establish administrator authentication to the server?
What is redo log?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?