Select * from (select e.*,rownum r from emp e) where r in(1,(select count(*

how to retrieve 1st and last row of table without using
group functions??

Question Posted / ajay reddy

Answer Posted / ajay reddy

Select * from (select e.*,rownum r from emp e) where r in(1,(select count(*) from emp));

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is an oracle cursor variable?

1066

Explain about your project and its relation to the current job position you are applying to?

1000

How to convert numbers to characters in oracle?

1026

How many types of cluster table in Oracle?

1030

Hi Can any one tell me what are the API's used in requisition import.

1917

What is dual table oracle?

978

What is varray?

1124

What are the execution control statements?

1061

How to count duplicated values in a column in oracle?

1036

Please explain compound trigger in oracle?

1051

How to call a sub procedure?

1089

Why do you create or replace procedures rather that drop and recreate.

1000

Oracle

2371

How to build data dictionary view an new database?

1000

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1997