Hi Everyone,
How to get fist and last record from a table in oracle?
Thanks in advance
Answers were Sorted based on User's Feedback
Answer / rajesh venati
select * from table_name where rownum=1
union
select * from table_name where rowid=(select max(rowid) from
table_name);
| Is This Answer Correct ? | 27 Yes | 5 No |
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);
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / chandana
select * from table_name
where rowid in ((select min(rowid) from table_name),
(select max(rowid) from table_name));
| Is This Answer Correct ? | 8 Yes | 0 No |
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);
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / samr
use Northwind
go
select top(1) * from Orders
union
select * from orders where orderid =
(select MAX(OrderID) from Orders)
| Is This Answer Correct ? | 2 Yes | 2 No |
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ataullah
Select * from emp where rowid=(select max(rowid) from emp) or rowid=(select min(rowid) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ashwani kumar singh
SELECT * FROM EMP WHERE ROWNUM < 2
UNION
SELECT * FROM (SELECT * FROM EMP ORDER BY EMPNO DESC )
WHERE ROWNUM < 2
| Is This Answer Correct ? | 1 Yes | 2 No |
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
| Is This Answer Correct ? | 0 Yes | 1 No |
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
| Is This Answer Correct ? | 0 Yes | 2 No |
How can check sql version from command line?
What is sql*plus?
how to convert numeric values to character strings? : Sql dba
What is sql partition function?
What is the size of partition table?
What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
. 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
please explain database architecture..
Is delete faster than truncate?
What jobs use sql?
Why stored procedures are faster than query?
What does the hierarchical profiler does?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)