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

What is sql*loader and what is it used for? : aql loader

1250

Can sql developer connect to db2?

1104

What are system versioned tables?

1074

What are the parameter modes supported by pl/sql?

1154

Why do we need cursor in pl sql?

1187

what are the differences between char and varchar? : Sql dba

1119

Can a select statement fire a trigger?

1209

What is rownum?

1034

What is primary key and foreign key with example?

981

what is try_catch block in procedure

1809

What do you mean by field in sql?

1126

What are the different sql commands?

1127

What do you understand by pl/sql cursors?

1148

What is linq to sql?

1178

I need a function for a train ticket reservation please answer it thanks in advance

1078