How we get last 2 transactions data in table using ms sql query

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi everyOne,

I have One Table 'tbl_student' fields are (Name,Class,Age,Address) OK.

No id column(primary key and identity ok)in my table.
I entered records,

Name Class Age Address
------ ------ ----- --------
Mohan X 18 Erode
Kumar XII 20 Chennai ---->1
Arun XI 19 Trichy
Bala VII 17 Coimbatore ---->2
Vijay VIII 17 Chennai
Karthi X 19 Erode

I stored 'Kumar' and 'Bala' Details(1,2) finally ok.
then...

How I get these Last 2 TRANSACTIONS from sql query
any One Known plz tell me....

By from Mohan.

Posted 9-May-11 0:32am

Mohankumar.Engain

Add a Solution

2 solutions

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)

Sandeep Mewara · Answer 1 · 2011-05-09T00:51:00

Solution 1

Last 2 TRANSACTIONS from sql query
Sounds like you are looking at time based records. In order to have it, add one more column to the table 'LastUpdated'. Populate it at the time of insertion/updation. Once you have this data in the table, you can get the first, last or time range based data whenever needed.

Posted 9-May-11 0:51am

Sandeep Mewara

Comments

Mohankumar.Engain 10-May-11 1:55am

thanks

Pete O'Hanlon · Answer 2 · 2011-05-09T00:55:00

You can't retrieve data based on the transactions. You could retrieve the row_number(), but this would only tell you the records inserted, which is not necessarily the last transactions because one transaction might be an update. With that constraint in mind, the way to do this would be to use something like

SQL

select top 2 row_number() over (order by Name desc) as 'RowNum', ...
from tbl_student
group by Name
order by Name desc

Note that I haven't tested this, it's just been entered in the editor so you may have to tweak the syntax a little bit.