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

How to list all tables in your schema?

1006

What happens if the imported table already exists?

990

How to assign values to data fields in record variables?

990

what are archived logs?

2162

What does sharding mean?

961

Explain the use of rows option in imp command.

1055

What is meant by joins? List out the types of joins.

982

What are the different types of modules in oracle forms?

967

What are the extensions used by oracle reports?

1006

What is oracle analytical function?

1058

How do you store pictures in a database?

967

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5461

How does Oracle guarantee data integrity of data changes?

2354

How many types of tables supported by oracle?

1033

How to revoke create session privilege from a user in oracle?

978