Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367658 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 / praveenkumar
SELECT salary FROM EMPtable
WHERE salary NOT IN ( SELECT MAX(salary)
FROM EMPtable)
ORDER BY salary DESC
FETCH FIRST ROW ONLY
---
We have verified and its working
fine.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does postgresql run on the cloud?
What is the location of pre_defined_functions.
Explain aggregate functions are available there in sql?
What is primary key and foreign key?
What is 19 null in sql?
What are the different type of joins in sql?
what is the difference between a having clause and a where clause? : Sql dba
What are records give examples?
What is the use of & in pl sql?
Does inner join return duplicate rows?
what is the difference between undefined value and null value? : Sql dba
Can we alter stored procedure?
How do I count duplicates in sql?
How many commands are in sql?
What are procedures used for?
