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

what are numeric data types? : Sql dba

761

How do you sort in sql?

774

Why function is used in sql?

679

How can you view the errors encountered in a trigger?

735

What does subquery mean in sql?

739

What is use of package in pl sql?

713

what is 'mysqlimport'? : Sql dba

725

Explain commit, rollback and savepoint.

766

Can we create a trigger on view?

668

How delete a row in sql?

719

How can you load multi line records? : aql loader

804

What is rollback?

786

What are different types of sql commands?

698

What is the difference between row level and statement level trigger?

726

Explain aggregate functions are available there in sql?

752