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

What is the main use of a namespace?

0 Answers  

What are the difference between structure and class?

0 Answers  

how to get dynamic control array position or its index position?

0 Answers   CMC,

Explain option strict?

0 Answers  

what are the advantage in vb.net and different between vb and vb.net

6 Answers   Data Entry Operator, Infosys, TCS, Zansa,

What are all the parts of .net framework?

0 Answers  

What is the role of new keyword?

0 Answers  

What is code access security?

0 Answers  

Write a program to find all text files in a logical drive and return the count of the number of files?

0 Answers  

Can we use a crystal report into a another crystal report

7 Answers  

What is an abstract class?

4 Answers  

Explain about the performance of visual basic?

0 Answers