Interested to Buy Any Domain ? << Click Here >> for more details...
Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
- 10 Answers
- 15437 Views
- Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon, I also Faced
- E-Mail Answers
Answer Posted / samad
Dear
here i am sending new ans u can give the value in parameter
SELECT SAL,NO FROM(
SELECT SAL ,ROWNUM NO FROM
(SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC)) WHERE NO=:N
Regards,
Samad
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
20. Using a set operator, display the client number of all clients who have never placed an order.
How index is implemented in oracle database?
What are the advantages of oracle?
Are truncate and delete commands same? If so why?
What is the difference between alert log file and tarce file ?
Differentiate between translate and replace?
Why does Oracle not permit the use of PCTUSED with indexes?
How to rollback the current transaction in oracle?
How to define a data field as not null?
Explain the use of compress option in exp command.
How to execute a stored program unit?
How to export your connection information to a file?
what are steps for interface? where is exchange rate defined in which table?
What is the sql query to concatenate column values from multiple rows in oracle?
How to do clean up if create database failed?
