Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361412 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
Can we use ddl statements in stored procedure?
Does a user_objects view have an entry for a trigger?
Why do we use joins in sql?
How do you bind variables in pl sql?
What are some predefined exceptions in pl/sql?
What is sql injection owasp?
What is difference between sql and mysql?
What does count (*) mean?
What mean sql?
Explain cursor types?
How do I tune a sql query?
What is a pdo connection?
what are the 'mysql' command line options? : Sql dba
Why is sql important?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
