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

Write a sql query to find the names of employees that begin with ‘a’?

991

What will you get by the cursor attribute sql%rowcount?

1018

how many columns can be used for creating index? : Sql dba

932

Can we change the table name in sql?

926

Why cross join is used?

1061

What is nosql db?

955

What are properties of the transaction?

991

Define SQL and state the differences between SQL and other conventional programming Languages?

1197

Can a primary key be a foreign key?

1005

What is rtm stands for?

1079

How many columns should be in an index?

951

What is rownum and rowid?

1019

Is a foreign key always unique?

922

What is composite primary key in sql?

982

what is a materialized view? : Sql dba

1048