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 to select unique records from a table? : Sql dba

1176

Explain what is a subquery ?

1245

How do I restart sql?

1027

What is pl sql architecture?

1006

how to start mysql server? : Sql dba

1239

Can you skip header records while loading? : aql loader

1102

What are the different type of joins in sql?

1000

What is a heap in sql?

1148

What is pl sql quora?

1231

what is table? : Sql dba

1109

Why we use join in sql?

1026

What is write ahead logging in sql server?

1101

Should I use mbr or gpt?

1063

What is procedure explain with program?

1068

How to disable a trigger name update_salary?

1316