SELECT * FROM tab a WHERE :n = (SELECT COUNT(rowid) FROM tab b WHE

how to retrive only second row from table?

Question Posted / sagar

Answer Posted / sagar

SELECT * FROM tab a
WHERE :n = (SELECT COUNT(rowid)
FROM tab b
WHERE a.rowid >= b.rowid);

Is This Answer Correct ?

14 Yes

33 No

Please Help Members By Posting Answers For Below Questions

Is it possible to create the following trigger: before or after update trigger for each row?

1292

How to read/write files from pl/sql?

1044

Can a composite key be null?

984

What is not null in sql?

1061

What are triggers and its uses?

1051

what is single byte over head in oracle..?

2407

Define tables and fields in a database

1139

What is percent sign in sql?

1289

when MSQL8.0 is in market

2082

How many tables can you join in sql?

964

what is primary key? : Sql dba

1035

what are the join types in tsql? : Transact sql

1068

What is benefit of creating memory optimized table?

975

What company owns postgresql?

1035

How much does sql cost?

1013