select top 1 * from (select top 3 * from cmdview

how to retrive only second row from table?

Question Posted / yogendra

Answer Posted / yogendra

select top 1 * from (select top 3 * from
cmdview_expertmaster order by expid) q order by expid desc

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How many types of indexes are there in sql?

985

what are date and time data types in mysql? : Sql dba

972

What are types of indexes in sql?

1084

How to return an array from java to pl/sql?

1143

How many clustered indexes can you have?

975

what is bcp? When is it used?

1115

What is difference between db2 and sql?

1005

Can we write dml inside a function in sql server?

956

What is sqlexception in java?

999

What are the ddl commands?

1012

What are triggers in sql?

1023

What is sql and explain its components?

1070

Explain isolation levels. : Transact sql

1074

What is java sql driver?

1129

What are all ddl commands?

1085