Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373098 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 / sai
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is a secondary key the same as a foreign key?
How do I add a database to sql?
Enlist some predefined exceptions?
What is scope of pl sql developer in future?
Can a foreign key have a different name?
What do you mean by field in sql?
Explain the difference between sql and mysql.
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is AUTH_ID and AUTH_USER in pl/sql ?
how to check server status with 'mysqladmin'? : Sql dba
What is the use of triggers?
What is the maximum rows in csv?
How can you load multi line records? : aql loader
Can cursors be part of a trigger body?
what are all the different types of indexes? : Sql dba
