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

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  

The Difference between 'Count' and 'Count(*)'

13 Answers  

In what sequence sql statement is processed?

0 Answers  

explain the type of contraints

3 Answers  

What are partitioned views?

0 Answers  

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

How we can compare two database data?

0 Answers  

What is difference between clustered and non clustered index?

0 Answers  

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

Do you know what is openxml in sql server?

0 Answers  

Explain the disadvantages of cursors?

0 Answers