Click here to Skip to main content
12,505,902 members (56,157 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# ASP.NET
i want to get last record from database


is there any similar function as TOP which we use to fetch 1st record

SELECT TOP 1 sponcorid FROM Registration_Master

i want such function to fetch last record
Posted 16-Nov-12 18:54pm
Updated 16-Nov-12 19:09pm
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

You could try...

SELECT TOP 1 sponcorid FROM Registration_Master
order by sponcorid desc 
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Based on unique id number.
SELECT *
FROM    TABLE
WHERE   ID = (SELECT MAX(ID)  FROM TABLE)

Use this query to get last record from database.
  Permalink  
v2
Comments
biswarup88 17-Nov-12 1:31am
   
good answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160927.1 | Last Updated 19 Nov 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100