Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373288 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / kasiraya
SELECT SALARY
FROM
(
SELECT ROW_NUMBER() OVER( ORDER BY SALARY DESC) AS
SL_NO,SALARY
FROM EMP
ORDER BY SALARY DESC
)
WHERE SL_NO=2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a design view?
what are all the different normalizations? : Sql dba
What is the difference between view and stored procedure?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
which operator is used in query for pattern matching? : Sql dba
Is not equal in sql?
How do you create an update query?
Mention what is the use of function "module procedure" in pl/sql?
What is rowid in sql?
How to call shell script from pl sql procedure?
Why is nosql good?
What are user defined functions?
What are the dml statements?
If a cursor is open, how can we find in a pl/sql block?
Which join condition can be specified using on clause?
