select * from ( select ROW_NUMBER() OVER (ORDER BY alias) as rowid ,alia

how to retrive only second row from table?

Question Posted / shince jose

Answer Posted / shince jose

select * from (

select ROW_NUMBER() OVER (ORDER BY alias) as rowid ,alias

from tbl) a where rowid=2.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I create a memory optimized filegroup?

948

Explain unique key in sql.

996

What do you mean by field in sql?

1071

How is a PL/SQL code compiled?

1208

What is cursor explain with example?

966

What is pragma in sql?

1059

What is the difference between database trigger and stored procedure?

1060

What is hibernate and its relation to sql?

1103

What are the types of index in sql?

1053

What are sql triggers used for?

980

what is a unique key ? : Sql dba

1080

What is a unique constraint?

1062

What is sql indexing?

1002

how can we find the number of rows in a table using mysql? : Sql dba

1069

What are the limitations of sql express?

1049