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 group functions in oracle?

986

Can objects of the same schema reside in different tablespace?

1013

What is translate in oracle?

1053

What is ADDM Advisor in Oracle?

1124

How to use "for" statements in oracle?

1027

How to create a temporary table in oracle?

1205

Please explain oracle left join with an example?

968

How to write date and time literals in oracle?

958

What is oracle datasource?

932

What happens to the current transaction if a ddl statement is executed?

958

How to call a sub procedure?

1045

What are data pump export and import modes?

1025

Will you be able to store pictures in the database?explain.

938

What is a view and how is it different from a table?

985

What is coalesce function?

1021