Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 91331 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / annada
SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary
that will return 2nd highest salry .if we place insted of 1
as 2 then we can get 3 rd highest salary .
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is oracle join syntax?
How to do a full database export?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to define an oracle cursor variable?
What are the differences between number and binary_float in oracle?
How do I start tns listener?
How to use "if" statements on multiple conditions?
Explain the truncate in oracle?
How to convert raw data type into text in oracle? Explain
What are the major difference between truncate and delete?
What is a named program unit?
What is query image?
What is difference between sid and service name in oracle?
What are the benefits of ordbms?
what is normalisation?what are its uses?
