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 get a list of indexes of an existing table? : Sql dba

955

What is data type in database?

986

How many databases can sql express handle?

979

What is the maximum number of rows in sql table?

1022

How do I run sql?

1177

How do I run sql profiler?

1060

Can we rename a column in the output of sql query?

993

What do you mean by stored procedures?

1008

What is a full join sql?

1054

How do I view output in sql developer?

1082

How do you use a while loop in pl sql?

1006

what is a join? : Sql dba

1027

Can we enter data in a table in design view?

965

What are the advantages of pl sql over sql?

1022

Do we need to rebuild index after truncate?

1031