how to find the second highest salary from emp table?
- 211 Answers
- 322095 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 / pramila
not only seceond highest . you can retrieve 2nd , 3rd.....
highest salary form this query
select min(Salary) from
(select distinct top 2 Salary from tblCategory order by
Salary desc) as tblCategory
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List out the acid properties and explain?
What does where 1 1 mean in sql?
What are the disadvantages of not performing database normalization?
How to take user input in pl sql?
Why procedure is used in sql?
Which software is used for pl sql programming?
What is autocommit sql?
what are the 'mysql' command line options? : Sql dba
How to execute a stored procedure?
Mention what plvcmt and plvrb does in pl/sql?
What is sqlite used for?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is difference between cursor and trigger?
How many types of normalization are there?
What does 0 mean in sql?
