Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367590 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
Why are cursors used?
What is pessimistic concurrency control? : Transact sql
Is join and inner join the same?
What is online transaction processing (oltp)?
Define SQL and state the differences between SQL and other conventional programming Languages?
How do I create an index in word?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is the difference between sum and count in sql?
Can we create foreign key without primary key?
What is constant in pl sql?
Can we use views in stored procedure?
Can we delete column in sql?
Why do you partition data?
What is mdb stand for?
What does the base_object_type column shows in the user.triggers data dictionary view?
