Hi, select top 1 * from (SELECT TOP 2 * from emp) A Order by empno des

how to retrive only second row from table in sql server
2000?

Question Posted / suresh

Answer Posted / suresh

Hi,

select top 1 * from (SELECT TOP 2 * from emp) A Order by
empno desc

Is This Answer Correct ?

16 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

898

What is sqlcmd?

1036

Describe in brief system database.

1005

What is entity data services?

1048

Why do we need normalization?

920

How to apply cascading referential integrity in place of triggers?

1026

what is a sub-report?

140

How to drop an existing schema in ms sql server?

1089

What is normalization? What number of normalization shapes are there?

1098

What is a domain constraint give an example?

1043

Explain what are the authentication modes in sql server?

1005

Where views are stored in sql server?

978

How do I start and stop sql server?

1012

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2739

What number aggregate functions are accessible there in sql?

1066