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
- 50751 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohammad murtuza ali
select * from salary where rowno<6
| Is This Answer Correct ? | 4 Yes | 15 No |
Answer / amit bharane
select salary from employees
where rownum<=5
order by salary desc
| Is This Answer Correct ? | 3 Yes | 22 No |
Answer / mohammad murtuza ali
select * from SALARY where where rowno<6 and empname like
empname
| Is This Answer Correct ? | 2 Yes | 29 No |
Answer / sujith
select * from test_sujith where rownum < 6 order by item3 desc
| Is This Answer Correct ? | 2 Yes | 31 No |
Why do we use joins in sql?
explain the delete statements in sql
Is it possible to read/write files to-and-from PL/SQL?
How do temporal tables work?
How does left join work in sql?
define primary key & secondary key?
What does plv msg allows you to do?
I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible
Why we use joins in sql?
What are the steps for performance tuning.
What is sqlca in powerbuilder?
What is the difference between left and left outer join?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
