Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368251 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 / mangesh pardhi
SELECT salary
FROM employee e
WHERE 2=(SELECT COUNT(DISTINCT salary)
FROM employees
WHERE e.salary<=salary)
--replace the number with 2,3,4 u wil find the that position
salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is data abstraction in sql?
Explain the difference between drop and truncate commands in sql?
How do I count rows in sql query?
Can we edit a view in sql?
Why do we use joins in sql?
Is keyword pl sql?
How do I delete a trigger?
How do you determine the current isolation level? : Transact sql
What is sp_helptext?
what is a record in a database ? : Sql dba
what is a materialized view? : Sql dba
What is a design view?
What are the basic sql commands?
What is database migration?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
