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 delete a trigger?

962

What is sqlca in db2?

951

What is meant by truncate in sql?

1064

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

1083

how to delete an existing column in a table? : Sql dba

1005

What is cost in sql execution plan?

978

How many databases can sql express handle?

981

Is a table valued function object?

1010

What is a loop in sql?

982

Does a primary key have to be a number?

963

Where not exists in sql?

976

How to get help at the sql prompt?

1111

What is difference between sql and mysql?

1128

What is count * in sql?

993

Can we edit a view in sql?

983