sql satement for 2nd maximum value
Answers were Sorted based on User's Feedback
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 |
Answer / manikandan
select distinct top 2 salary from employee order by salary
desc
Is This Answer Correct ? | 3 Yes | 4 No |
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 |
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 |
Answer / rohan patil
Select * from author where rownum=2
order by ID desc
Is This Answer Correct ? | 5 Yes | 20 No |
Explain how can we remove handlers at run time?
Explain the difference between an xml "fragment" and an xml "document."
What is MSIL
Explain the difference between datatable and dataset?
Explain and brief about rapid application development tool?
Is vb.net a programming language?
What are the different types of a stream?
In vb.net how to connect crystal report?
What is the significance of delegates. Where should they be used?
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?
Explain the components of common language runtime.