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 are the four Oracle system processes that must always be up and running for the database to be useable?

1048

What is an oracle function?

1240

What is the relation of a user account and a schema in oracle?

1126

How to connect the oracle server as sysdba?

1126

How to create a table interactively?

1161

What is an oracle database table?

1061

How to define an anonymous procedure with variables?

1236

Is primary key indexed by default in oracle?

1046

Explain temporal data types in oracle

1133

What is a table index?

1165

Give syntax for SQL and ORACLE joins.

1144

What is dynamic proxy?

1049

How to generate query output in html format?

1206

State the various uses of dbcc command?

1103

How to increment dates by 1 in oracle?

1134