select top 1 rate from HumanResources.EmployeePayHistory where rate<

how to find the second highest salary from emp table?

Question Posted / anil maurya

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

Please Help Members By Posting Answers For Below Questions

Does postgresql run on the cloud?

1154

Is pl sql a programming language?

998

What is a table in a database?

1052

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1164

What is vector point function?

1057

Can we create table in function?

969

How long does it take to learn pl sql?

1067

What is the best free sql database?

1058

how to fetch common records from two tables? : Sql dba

1183

What is a data definition language?

1144

What is integrity in sql?

1053

Which is faster subquery or join?

1228

How can you load multi line records? : aql loader

1083

What are the three pl sql block types?

1013

how to create a new table by selecting rows from another table in mysql? : Sql dba

1114