how to find the second highest salary from emp table?
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
Does postgresql run on the cloud?
Is pl sql a programming language?
What is a table in a database?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What is vector point function?
Can we create table in function?
How long does it take to learn pl sql?
What is the best free sql database?
how to fetch common records from two tables? : Sql dba
What is a data definition language?
What is integrity in sql?
Which is faster subquery or join?
How can you load multi line records? : aql loader
What are the three pl sql block types?
how to create a new table by selecting rows from another table in mysql? : Sql dba