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

What is replication with database mirroring? : sql server database administration

0 Answers  

What does it mean to invest in the index?

0 Answers  

What is the difference between NOROW and LOCKROW?

0 Answers   Accenture, Honeywell, Satyam,

What are the different types of joins and what does each do?

2 Answers  

Explain full-text query in sql server?

0 Answers  

What is store procedure?

0 Answers  

What is msdb database? : SQL Server Architecture

0 Answers  

What are the database roles? : sql server security

0 Answers  

Why main is user defined function?

0 Answers  

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

What are the essential components of sql server service broker?

0 Answers  

How to create a ddl trigger using "create trigger" statements?

0 Answers