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 is the difference between truncate & delete command?

1123

Explain the use of record option in exp command.

946

Design database draw er diagram for a certain scenario ?

4528

What are the original export and import utilities?

1057

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2259

Explain what are the different type of segments?

912

What are the restrictions on external table columns?

991

How to invoke the data pump export utility?

1115

Is there an oracle sql query that aggregates multiple rows into one row?

931

What is where clause in oracle?

981

What is ceil and floor in oracle?

1007

How to turn on or off recycle bin for the session?

1036

What do you understand by database schema and what does it hold?

1177

material view and view disadvantages?

1017

Differentiate between post-database commit and post-form commit?

979