Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361151 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 sql constant?
Is sql better than access?
What is pls_integer in pl sql?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is the difference between left and left outer join?
How to write a query to show the details of a student from students table whose
How to execute a stored procedure?
Can we change the table name in sql?
What are the usages of sql?
Show how functions and procedures are called in a pl/sql block.
What is the difference between pl and sql?
Why indexing is needed?
What is sequence in sql?
How do I run a sql trace?
which types of join is used in sql widely? : Sql dba
