Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373233 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 / anil maurya
select top 1 rate from HumanResources.EmployeePayHistory
where rate<(select MAX(rate) as R from HumanResources.EmployeePayHistory)
order by rAte Desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a relationship and what are they?
What is data control language (dcl)?
Explain clause in sql?
Explain ttitle and btitle.
Explain about various levels of constraint.
What is the use of sqldataadapter?
What is sql stand for?
What is interval partition?
Why do we need a foreign key?
What is the difference between in and between in sql?
What are different types of statements supported by sql?
What has stored procedures in sql?
Advantages and disadvantages of stored procedure?
Why are aggregate functions called so?
What is the difference between local variables and global variables?
