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 between Abstract Classes and Interfaces? Give the answer as a table format....

5 Answers  

---

How to connect a service based database to vb.net forms? Do we have to create any specific database?

1 Answers  

---

What is MSIL

8 Answers  

---

Which control is an example of an object in vb net?

0 Answers  

---

What’s the difference between private and shared assembly?

0 Answers  

---

---

is ADO.NET important to connect sql server? is any other way to connect sql server?

1 Answers  

---

What is enumerator?

0 Answers  

---

What are the different types of a stream?

0 Answers  

---

What is the feature which is common to all .net languages?

0 Answers  

---

Name the class which allows an element to be accessed using unique key?

0 Answers  

---

1.wht is satellite assembly??? 2.How Garbage Collector works can u explain ????

3 Answers   ABC,

---

Explain the services provided by common language infrastructure.

0 Answers  

---