Sql Query to select last Row of The Table

Question

1.00/5 (1 vote)

See more:

Dear Friends

How can Select Only last Row of the Table Using Sql

if i have Table 100 rows now i want Select 99th row without passing field name

eg i have table like this

openingBalance Purchase Sale ClosingBalance
100 10 10 100
100 20 10 110
110 25 30 105
105 100 5 200
200 20 10 210
210 55 100 465

in this i want Select last Row

Posted 17-Oct-13 23:12pm

murkalkiran

Updated 15-Mar-21 14:57pm

Add a Solution

4 solutions

Solution 5

Try the following code. . .

SQL

DECLARE @MYVAR NVARCHAR(100)
Declare @MyVar2 nvarchar(100)
DECLARE MYTESTCURSOR CURSOR
DYNAMIC 
FOR
SELECT EmpID,EmpName FROM Employees
OPEN MYTESTCURSOR
FETCH LAST FROM MYTESTCURSOR INTO @MYVAR,@MyVar2
CLOSE MYTESTCURSOR
DEALLOCATE MYTESTCURSOR
SELECT @MYVAR,@MyVar2

Posted 18-Oct-13 0:41am

Dipesh Wadhwa

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Accepted Answer · 2013-10-17T23:53:00

It's not difficult to select the first or last row - that's just a case of ordering your inputs and using SELECT TOP 1:

SQL

SELECT TOP 1 * FROM MyTable ORDER BY MyColumn ASC

Will give you the first, and

SQL

SELECT TOP 1 * FROM MyTable ORDER BY MyColumn DESC

will give you the last.
In your case however, it may not be possible at all because you have no column on which to sort - and if you do not specify a sort order then SQL is at liberty to return rows in any order it sees fit - and that order can change between two successive runs if SQL decides to reorganise it's tables for greater efficiency.

I think you need to look at adding a column to your table which "date stamps" each row according to when it was created to allow you a positive ordering mechanism. If you don't, then any other solution which works at present may fail randomly in the future, with potentially harmful results.

midhun3600 · Accepted Answer · 2013-10-17T23:48:00

Solution 2

select top 1 * from Table_Name order by ID desc

Posted 17-Oct-13 23:48pm

midhun3600

seyed mahmud shahrokni · Accepted Answer · 2013-10-17T23:56:00

Solution 4

I think that is the answer to your question

SQL

select top(1) * from YourTable order by First-Field-Of-Table desc

first field = praimer key or identity

Posted 17-Oct-13 23:56pm

seyed mahmud shahrokni

Updated 18-Oct-13 0:27am

v2