In this blog I will post all FAQs, code snippets, real time problems and solutions and any other links which I feel every one needs and can take advantage of.
Query to find first and last records of a table
Posted 13-11-07 at 11:34 PM by sk_kireeti
select * from
(select rownum sno, empno,ename from emp)
where
sno =1
or sno=(select count(*) from emp);
(select rownum sno, empno,ename from emp)
where
sno =1
or sno=(select count(*) from emp);
Total Comments 0
Comments
Recent Blog Entries by sk_kireeti
- Selecting alternative records in Oracle (14-10-08)
- Oracle SQL to HTML table (14-10-08)
- SQL to select middle record of a table (13-11-07)
- Query to find first and last records of a table (13-11-07)




