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 are the numeric comparison operations?

1167

What happens if you use a wrong connect identifier?

1140

What is connection pool in oracle?

1037

What is blob datatype?

1197

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2335

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

2047

Difference between oracle's plus (+) notation and ansi join notation?

1160

What are the differences between blob and clob in oracle?

1135

How to define a data field as not null?

1162

How to assign values to data fields in record variables?

1077

Differentiate between pre-select and pre-query?

1153

Explain the use of record option in exp command.

1065

What is meant by recursive hints in oracle?

1131

How to start a specific oracle instance?

1080

What is Redo Log Buffer in Oracle?

1279