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

What are the basic sql commands?

1139

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1146

How many sectors are in a partition?

1117

explain advantages of innodb over myisam. : Sql dba

1175

What is sql resultset?

1039

Why do we use triggers?

1015

What is the difference between union and union all command?

1151

What does varchar include?

992

What is right join sql?

1013

What is the usage of the distinct keyword?

1274

How do you declare a variable in pl sql?

1070

What are the two virtual tables available at the time of database trigger execution?

1271

differentiate between float and double. : Sql dba

1110

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3620

What are the types of index in sql?

1118