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

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  

What is the command used to get the version of sql server?

1 Answers  

Explain an automatic checkpoint

0 Answers  

What is the contrast amongst drop and truncate?

0 Answers  

Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

What does the update command do?

0 Answers  

Explain sql delete command?

0 Answers  

when inserting to a table how many rows will be effected using triggers

2 Answers  

What is wrong with sql server client libarary dll, ntwdblib.dll?

0 Answers  

What is advantage data architect?

0 Answers  

Explain about SQL server 2005?

0 Answers