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

Is sql harder than python?

1039

Can we connect to postgresql using sql developer?

938

Which is better stored procedure or query?

922

What is oracle sql developer?

994

Does sql full backup truncate logs?

968

What is scalar function in sql?

979

Explain alias in sql?

997

Can delete statement be rollbacked?

932

does sql support programming? : Sql dba

993

What is trigger point?

950

what is bdb (berkeleydb)? : Sql dba

976

Why are aggregate functions called so?

897

what is clause? : Sql dba

1006

What are variables in pl sql?

1094

Is left join same as join?

939