a query to select maxmun 3 salaries of employee table
Answer Posted / tulasi
select * from (select * from emp order by sal desc) where
rownum<=3;
Is This Answer Correct ? | 21 Yes | 5 No |
Post New Answer View All Answers
What are the different types of trigger and explain its various uses and functions?
How to define a variable to match a table column data type?
How can we force the database to use the user specified rollback segment?
What is the difference between PFILE and SPFILE in Oracle?
Why do we use coalesce function in oracle?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What are group functions in oracle?
How do we get field details of a table?
What are the set operators union, union all, minus & intersect meant to do?
What is a read only transaction in oracle?
How to write text literals in oracle?
How to convert a string to a date in oracle database?
What are the different types of synonyms?
How can we find out the duplicate values in an oracle table?