Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 47564 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / mohammad murtuza ali
select * from emp as(empname,empsal,empdesc) where rownum<6
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How to handle bulk data?
What does sign mean sql?
What is meant by truncate in sql?
Explian rowid, rownum?
what is the difference between a having clause and a where clause? : Sql dba
Which version of sql do I have?
what are the advantages of using stored procedures? : Sql dba
What is oracle and pl sql?
Why stored procedures are faster than query?
What are the types of records?
Mention what is the plv (pl/vision) package offers?
Which data type is a composite type?
what is a cursor? : Sql dba
how to rename an existing column in a table? : Sql dba
What is auto increment in sql?
