select* from employees where rowid=(select min(rowid) from employees) uni

How to retrieve first and last records from a table?

Question Posted / avnish srivastava-test engg fc

Answer Posted / avnish srivastava-test engg fc

select* from employees where rowid=(select min(rowid) from
employees)
union
select* from employees where rowid=(select max(rowid) from
employees)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a tns service name?

530

20. Using a set operator, display the client number of all clients who have never placed an order.

1793

What is a initialization parameter file in oracle?

578

What is literal?

585

Explain database link?

660

How to convert numbers to characters in oracle?

583

Explain oracle data types with examples?

575

What privilege is needed for a user to create views in oracle?

586

What is parameterized cursor in oracle?

573

How to write a query with an inner join in oracle?

560

What are dml statements in oracle?

615

Can the query output be sorted by multiple columns in oracle?

568

How to add another datafile to a tablespace?

574

What is dynamic proxy?

547

Can a formula column referred to columns in higher group ?

2083