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

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

637

What is oracle host variable?

531

How to use select statement to count the number of rows in oracle?

547

Name the three major set of files on disk that compose a database in Oracle?

627

How to write an inner join with the where clause in oracle?

573

How are extents allocated to a segment?

571

How to omit columns with default values in insert statement in oracle?

571

What is a database schema in oracle?

612

How to lock and unlock a user account in oracle?

607

How to insert multiple rows with one insert statement in oracle?

564

Can we protect our pl/sql source code?

570

What is Trigger in Oracle?

565

How to apply filtering criteria at group level in oracle?

577

Does oracle charge for java?

577

Why oracle is used?

573