Forums.Sureshkumar.net : A Perfect Place to Share Knowledge         Blogs     Games    Magazines

"Sharing knowledge does not lessen your store, often it gets you more. Sharing plays a key role in relationships and bonding, happens in small steps and is assisted through community membership."

Go Back   SURESHKUMAR.NET FORUMS > Blogs > Elite world
Register FAQ Members List Calendar Games Blogs Search Today's Posts Mark Forums Read

   

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.
Rate this Entry

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);
Posted in Oracle SQL
Comments 0 Email Blog Entry
Total Comments 0

Comments

Post a Comment Post a Comment
Recent Blog Entries by sk_kireeti

All times are GMT +6.5. The time now is 05:42 AM.





Search Engine Optimization by vBSEO 3.1.0