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 oracle datasource?

924

Who developed oracle & when?

944

What is a data lock in oracle?

1015

How to define and use table alias names in oracle?

883

How to run create database statement?

975

How to do a full database export?

1044

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1810

What is the purpose of save points in oracle database?

1004

How to create a testing table in oracle?

945

How to define a record variable to store a table row?

1002

Explain the difference between replace() and translate() functions in oracle?

974

Explain what are the characteristics of data files?

1030

Explain oracle’s server parameter file.

947

What are named parameters?

1033

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2216