Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367448 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
How can we find duplicate records in a table?
Which are the different case manipulation functions in sql?
Why cross join is used?
What is the use of triggers?
How to order siblings in oracle hierarchy queries?
What is the order of sql select?
How many types of cursors supported in pl/sql?
What are the different tcl commands in sql?
What is the difference between nested table and varray?
Why is pl sql used?
Which data type is a composite type?
What do you think about pl/sql?
which tcp/ip port does sql server run on? : Sql dba
can a stored procedure call itself or recursive stored procedure? : Sql dba
How can we debug in PL/SQL?
