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 10: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
Post a Comment
|
Recent Blog Entries by sk_kireeti
- SQL to select middle record of a table (13-11-07)
- Query to find first and last records of a table (13-11-07)
Freshers
(0)