select * from emp a where 2=(select count(distinct(b.rowid)) from emp b whe

how to retrive only second row from table?

Question Posted / thanjairajan@gmail.com

select * from emp a where 2=(select count(distinct(b.rowid)) from emp b where a.rowid>=b.rowid;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to return query output in html format? : Sql dba

1023

What is on delete restrict?

945

What is the limitation on the block size of pl/sql?

938

what is 'mysqlshow'? : Sql dba

975

Explain scalar functions in sql?

1019

Why is a primary key important?

968

What is a clob in sql?

969

What is the source code of a program?

1005

Can we enter data in a table in design view?

913

Differentiate between sga and pga.

1091

What has stored procedures in sql?

996

What is sql used for?

1066

what are sequences

1622

Which sql most popular?

937

What is acid property in a database?

974