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 > TECHNICAL DISCUSSIONS > ORACLE , SQL SERVER , SYBASE & Others
Register FAQ Members List Calendar Games Blogs Search Today's Posts Mark Forums Read

   

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old 30-08-06, 07:51 PM   #1 (permalink)
Moderator
 
Join Date: Apr 2006
Location: India
Posts: 1,733
Thanks: 2
Thanked 143 Times in 132 Posts
Thanks: 2
Thanked 143 Times in 132 Posts
Rep Power: 31 vjsreevs is a splendid one to behold vjsreevs is a splendid one to behold vjsreevs is a splendid one to behold vjsreevs is a splendid one to behold vjsreevs is a splendid one to behold vjsreevs is a splendid one to behold vjsreevs is a splendid one to behold vjsreevs is a splendid one to behold vjsreevs is a splendid one to behold
SQL Refreshment Contest 10

how do we retrieve the last row of a table?
__________________
Sree
vjsreevs is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-09-06, 01:53 AM   #2 (permalink)
Junior Member
 
Join Date: Aug 2006
Posts: 24
Thanks: 1
Thanked 2 Times in 2 Posts
Thanks: 1
Thanked 2 Times in 2 Posts
Rep Power: 3 malhotra.mayank is on a distinguished road
Cool Re: SQL Refreshment Contest 10

select* from (SELECT ename,rownum FROM EMP order by rownum desc
) where rownum<2;
malhotra.mayank is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Refreshment Contest 8 vjsreevs ORACLE , SQL SERVER , SYBASE & Others 2 08-10-06 07:26 PM
SQL Refreshment Contest 9 vjsreevs ORACLE , SQL SERVER , SYBASE & Others 7 08-10-06 07:10 PM
SQL Refreshment Contest 3 vjsreevs ORACLE , SQL SERVER , SYBASE & Others 1 13-08-06 02:38 AM
SQL Refreshment Contest 5 vjsreevs ORACLE , SQL SERVER , SYBASE & Others 0 12-08-06 04:36 PM
SQL Refreshment Contest 4 vjsreevs ORACLE , SQL SERVER , SYBASE & Others 0 05-08-06 10:00 PM


All times are GMT +6.5. The time now is 09:38 PM.





Search Engine Optimization by vBSEO 3.1.0