Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367683 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 / mona thakur
SELECT *
FROM emp
WHERE salary < (
SELECT max( salary )
FROM emp )
ORDER BY salary DESC
LIMIT 1
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is integrity in sql?
What is the difference between joins?
What is union, minus and interact commands?
Why we use join in sql?
What is a sql driver?
How do I run a pl sql program?
What is trigger in sql?
Define tables and fields in a database
Does a primary key have to be a number?
what is a unique key ? : Sql dba
How do I find duplicates in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
How do you rename a table in sql?
What will you get by the cursor attribute sql%rowcount?
What type of database is cloud sql?
