For the 1st row: select * from emp where rownum<2 order by empno;

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

Question Posted / sudipta santra

Answer Posted / sudipta santra

For the 1st row:

select * from emp where rownum<2 order by empno;

For the last row:

select * from emp where rownum<2 order by empno desc;

Is This Answer Correct ?

14 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is Redo Log Buffer in Oracle?

1209

what is the difference between substr and instr function in oracle?

1090

What is a oracle database?

1056

How to execute the package in oracle?

1083

State the various uses of dbcc command?

1060

Calculate difference between 2 date / times in oracle sql?

1041

How to connect to a remote server?

1127

What is a select query statement in oracle?

968

What are operators in oracle?

1055

Can you drop an index associated with a unique or primary key constraint?

1019

What is a static data dictionary in oracle?

1113

What is SQL access advisor in Oracle?

1191

Which environment variables are absolutely critical in order to run the OUI?

2120

How to connect to oracle using service name instead of sid?

1026

Give the advantages and disadvantages of clusters.

1051