sql satement for 2nd maximum value

Answers were Sorted based on User's Feedback



sql satement for 2nd maximum value ..

Answer / sanjay

select top 1 EmployeeID,min(Rate ) from
(select top 2 EmployeeID ,Rate from
EmployeePay
order by Rate desc)table1 group by EmployeeID ,Rate

Is This Answer Correct ?    0 Yes 0 No

sql satement for 2nd maximum value ..

Answer / manikandan

select distinct top 2 salary from employee order by salary
desc

Is This Answer Correct ?    3 Yes 4 No

sql satement for 2nd maximum value ..

Answer / chandru teamwork

Oredrs is table name orderid is collum name


select top 1 * from Orders
where orderid <=(select max(OrderID) from Orders)

Is This Answer Correct ?    0 Yes 1 No

sql satement for 2nd maximum value ..

Answer / sunil nandedkar

Select min(Salary)ThirdHighest from employees where salary
in (Select top 3 salary from employees order by salary desc)
For nth replace top 3 with top n

Is This Answer Correct ?    3 Yes 5 No

sql satement for 2nd maximum value ..

Answer / rohan patil

Select * from author where rownum=2
order by ID desc

Is This Answer Correct ?    5 Yes 20 No

Post New Answer

More VB.NET Interview Questions

Explain how can we remove handlers at run time?

0 Answers  


Explain the difference between an xml "fragment" and an xml "document."

0 Answers  


What is MSIL

8 Answers  


Explain the difference between datatable and dataset?

0 Answers  


Explain and brief about rapid application development tool?

0 Answers  






Is vb.net a programming language?

0 Answers  


What are the different types of a stream?

0 Answers  


In vb.net how to connect crystal report?

1 Answers  


What is the significance of delegates. Where should they be used?

0 Answers  


what do you mean by .Net Framework

17 Answers   Assurgent, College School Exams Tests, Guru Tech, Krishna Infotech, Ksb, Microsoft,


How many classes a dll can contain?

0 Answers  


Explain the components of common language runtime.

0 Answers  


Categories