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 difference b/w Readonly Variable and Constant Variable?

7 Answers   Ksb, Sonata,

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

0 Answers   CMC,

What is private assembly?

0 Answers  

Explain the difference between import system.data.sqlclient and system.data.oledb?

0 Answers  

Described strong typing and weak typing?

0 Answers  

Explain the difference between system.string and system.stringbuilder classes?

0 Answers  

What is a preprocessor directive in vb.net?

0 Answers  

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

0 Answers  

Write a program that would find the nth term of a geometric progression, given the value of first term and common ratio. Any inbuilt function that the language provides for calculating exponent should not be used.

0 Answers  

hello dear friends my problem is that i want to save images that is pictures in SQL server using vb.net can any body help me to do so please

1 Answers  

Can we use a crystal report into a another crystal report

7 Answers  

What is redim keyword and its use?

0 Answers