Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368626 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
What view means?
How many primary keys can a table have?
What is the difference between left join and right join?
What are sql built in functions?
What is difference between sql and excel?
What are different clauses used in sql?
What are different types of sql commands?
How can check sql version from command line?
What plvcmt and plvrb does in pl/sql?
What is an oracle stored procedure?
What is input buffer in sql*plus?
what is a database transaction? : Sql dba
what is 'mysqlshow'? : Sql dba
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
what is the difference difference between procedure and packages
