Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 52285 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
What is transaction control language (tcl)?
Does truncate need commit?
how to increment dates by 1 in mysql? : Sql dba
explain advantages of myisam over innodb? : Sql dba
What is an index in sql with example?
What is difference between hql and native sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How is a PL/SQL code compiled?
What do you think about pl/sql?
Is a foreign key always unique?
How many rows can sqlite handle?
Why use truncate instead of delete?
How many types of sql are there?
What is over () in sql?
Which is faster truncate or drop?
