Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367896 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
Explain character-manipulation functions?
What are predefined functions in sql?
How do you know if a relationship is 2nf?
What is nosql db?
Can we create foreign key without primary key?
Is sql an operating system?
what is datawarehouse? : Sql dba
Can we create table inside stored procedure?
What is mutating table error?
How do sql databases work?
What is the difference between sql, mysql and sql server?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What are all the common sql functions?
What is Collation Sensitivity ? What are the various type ?
What is the basic structure of an sql?
