select * from (select a.*,rownum aa from orders a ) where aa=2 Please

how to retrive only second row from table?

Question Posted / rajasekar.p

Answer Posted / rajasekar.p

select * from (select a.*,rownum aa from orders a )
where aa=2

Please verify the same you will get the correct answer

Regards
P.Rajasekar

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do you write a subquery?

1023

What is interval partition?

1051

Is it possible to sort a column using a column alias?

1042

Is grant a ddl statement?

894

What are the various restrictions imposed on view in terms of dml?

963

What is the best sql course?

977

What is the life of an sql statement?

1020

List the ways to get the count of records in a table?

900

What is a full join?

972

how to convert character strings to dates? : Sql dba

1056

Can we use having without group by in sql?

982

What is nvarchar max in sql?

1011

Write an sql query to select all records from the table?

1026

What is raid? How does it help storage of databases?

1082

What is group by in sql?

1083