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 to get help information from the server? : Sql dba

939

What is a function in oracle pl sql?

1036

What is database sql?

1042

What is linq to sql?

1132

what is a trigger? : Sql dba

1024

how is myisam table stored? : Sql dba

1052

What is audit logout in sql profiler?

1022

What is a schema sql?

1147

What is a primary key example?

956

What is error ora-01000: maximum open cursors exceeded

1141

What are secondary keys?

969

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2483

What is database white box testing and black box testing?

1107

Can ddl statements be used in pl/sql?

1140

Is oracel sql developer written in java?

1101