Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 47558 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / sujith
select * from test_sujith where rownum < 6 order by item3 desc
| Is This Answer Correct ? | 2 Yes | 31 No |
Post New Answer View All Answers
What is informix sql?
Can we rollback after truncate?
Explain the working of foreign key?
what are the difference between clustered and a non-clustered index? : Sql dba
what tools available for managing mysql server? : Sql dba
what does the t-sql command ident_current does? : Transact sql
Explain the components of sql?
Which one is faster ienumerable or iqueryable?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Is left join faster than inner join?
Why truncate is used in sql?
Is t sql a programming language?
Why do we use joins?
What is full form of rtm?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
