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

Can you drop an index associated with a unique or primary key constraint?

1022

What is a schema in oracle?

1023

What is the dynamic sql in oracle?

1081

Why do you use stored procedures and state some of its disadvantages?

1028

What is the difference between online and offline backups?

1061

How can windows applications connect to oracle servers?

1059

Give syntax for SQL and ORACLE joins.

1096

How can Oracle users be audited?

1123

What is a table index in oracle?

1131

What is SQL Tuning Advisor in Oracle?

1185

Explain how you would restore a database using RMAN to Point in Time?

2148

What are the differences between char and nchar in oracle?

1098

How to connect to a local oracle 10g xe server?

995

How to define an anonymous procedure with variables?

1165

what is meant by magic query

2190