Answer / ramana

Table Like this

Create Table Employee(Name varchar(20),Location
varchar(20),Salary int)

Query Like this

Select top 1 * from employee where Name not in(select top 1
Name from Employee)

it will display second record....

Answer / madhuparna

select top 1 * from (select top 2 * from employee)A

Answer / prabhat sharma

select top 1 * from xyz where rno > (select top 1 rno from xyz)

rno is a column name and xyz is a table name

Answer / jayaraman b

select min(emp_no) from
(select top 2 * from emp order by emp_no desc)A
--This will give you the 2nd largest Salaried employee

select max(emp_no) from
(select top 2 * from emp order by emp_no desc)A
--This will give you the 1st largest Salaried employee

Answer / ravi

select top 2 from tablename

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

---

What is the use of DBCC commands?

4 Answers   NA,

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

How can I know what locks are running on which resource?

0 Answers  

---

wht's the differece between sqlserver05 and sqlserver2000

3 Answers  

---

---

What are the benefits of filtered indexes?

0 Answers  

---

What is query cost in sql server?

0 Answers  

---

What is the difference between upgrade and migration in sql server?

0 Answers  

---

Diffrent types of function

1 Answers   Wipro,

---

Define synonym?

0 Answers  

---

What is spid in sql server profiler?

0 Answers  

---

What is nolock?

0 Answers  

---