Answer / rajesh venati

select * from table_name where rownum=1
union
select * from table_name where rowid=(select max(rowid) from
table_name);

Answer / rajesh venati

this will also work

select * from table_name where rowid=(select min(rowid) from
table_name)
union
select * from table_name where rowid=(select max(rowid) from
table_name);

Answer / chandana

select * from table_name
where rowid in ((select min(rowid) from table_name),
(select max(rowid) from table_name));

Answer / ramesh

Select * from table_name where rowid =(select min(rowid)
from tanle_name)
union
select * from table_name where rowid = (select max(rowid0
from table_name);

Answer / samr

use Northwind
go

select top(1) * from Orders
union
select * from orders where orderid =
(select MAX(OrderID) from Orders)

Answer / venkyhulk1

select *
from (select rownum r, e.* from emp e)
where r in ((select max(rownum) from (select rownum , e.*
from emp e)),(select min(rownum) from (select rownum , e.*
from emp e)))


this querry will get the first and last records of the table
with respect to the way the data is stored in the table

Answer / ataullah

Select * from emp where rowid=(select max(rowid) from emp) or rowid=(select min(rowid) from emp)

Answer / ashwani kumar singh

SELECT * FROM EMP WHERE ROWNUM < 2
UNION
SELECT * FROM (SELECT * FROM EMP ORDER BY EMPNO DESC )
WHERE ROWNUM < 2

Answer / nitinmukhraiya

Rownum and RowID displays the results faster than others -

select * from <Table_Name> where rownum=1
union
select * from (select * from <Table_Name> order by rownum desc) where rownum=1

Answer / gourav

select * from emp(table name)
where rownum = 1 and 30



this query will display the first and last record


for eg rownum start from 1 and rownum last record is 30..by
execute this query u wil get frst and last reord

How do I count records in sql?

0 Answers  

How to start the command-line sql*plus?

0 Answers  

Can u create a primary key with out unique index.

8 Answers  

What is procedure and function in sql?

0 Answers  

What is rowid in sql?

0 Answers  

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

What is crud diagram?

0 Answers  

How to place comments in pl/sql?

0 Answers  

Which command is used to delete a trigger?

0 Answers  

How many types of primary keys are there?

0 Answers  

Is not null in sql?

0 Answers  

Does inner join remove duplicates?

0 Answers