how to retrive only second row from table?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to include numeric values in sql statements? : Sql dba

770


How do you modify a column in sql?

730


Which command is used to delete a trigger?

956


What is trigger in pl sql with examples?

722


What is autocommit sql?

708






What are sql queries used for?

762


What is the execution plan in sql?

759


Explain what is dbms?

787


How do I save the results of sql query in a file?

711


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

777


what are the join types in tsql? : Transact sql

755


How to Execute a Package in PL/SQL.?

807


What are the different types of sql commands?

786


How to change the order of columns in Oracle SQL Plus ?

792


Explain clause in sql?

749