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 can check sql version from command line?

0 Answers  

What is sql*plus?

0 Answers  

how to convert numeric values to character strings? : Sql dba

0 Answers  

What is sql partition function?

0 Answers  

What is the size of partition table?

0 Answers  

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

please explain database architecture..

1 Answers   Infosys,

Is delete faster than truncate?

0 Answers  

What jobs use sql?

0 Answers  

Why stored procedures are faster than query?

0 Answers  

What does the hierarchical profiler does?

0 Answers