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 logical backup in oracle?

772

What are advantages of dateset in datastage?

1980

Does oracle database need java?

735

What's dateware house and what's clustor with practicle example

1913

How different is ms access and oracle?

764

What do you mean by redo log file mirroring?

748

What is the difference between 10g OEM and 11g OEM?

735

How to get a create statement for an existing table?

741

What are the various constraints used in oracle?

778

Point out the difference between user tables and data dictionary?

755

What do you mean by cdb and pdb in oracle 12c?

831

Why cursor variables are easier to use than cursors?

777

What do you understand by a database object?

788

how the indexes are stored in the Oracle Database?

1956

What are ddl statements in oracle?

771