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

Answer / manikandan

select distinct top 2 salary from employee order by salary
desc

Answer / chandru teamwork

Oredrs is table name orderid is collum name


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

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

Answer / rohan patil

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

how to save items in gridview and the form name is vendor rating?

1 Answers  

What is the Difference between Web User Control and Web Custom Control?

6 Answers   Benchmark,

How does you call and execute a SP in .NET?

2 Answers  

Explain cts?

0 Answers  

What is the significance of delegates?

0 Answers  

Define clr?

0 Answers  

What is the difference between static or dynamic assemblies?

0 Answers  

Which is the tool which can convert visual basic old version to .net compatibility version?

0 Answers  

Define cls?

0 Answers  

described weak typing?

0 Answers  

What are nested classes?

0 Answers  

Can you please explain the difference between int and int32?

0 Answers