Answer Posted / aryasen vaikom
SELECT DISTINCT (a.sal)
FROM EMP A
WHERE 5= ( SELECT COUNT (DISTINCT (b.sal))
FROM EMP B
WHERE a.sal<=b.sal )
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are the differences between char and varchar2 in oracle?
Is oracle a language?
What is a tns file?
Can we write insert statement in function in oracle?
Difference between pre-select and pre-query
What is sharded cluster?
What is hot backup and logical backup?
How to create lov dynamically at runtime & attach to text field?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to loop through data rows in the implicit cursor?
Difference between the “verify” and “feedback” command?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What to do if the binary spfile is wrong for the default instance?
Please explain joins in oracle?
How can I introduce multiple conditions in like operator?