To get latest record

Question

0.00/5 (No votes)

See more:

Hi,

In a table i am having some records. out of those records, two records having simillar data but only difference in that two records is Record date.

Now i want to retrive the latest record of those 2 records and following the other records.

Adcvice a query for this.

Thanks in Advance
Subhash G.

Posted 20-Jul-11 19:44pm

subhash04573

Updated 20-Jul-11 21:43pm

v3

Add a Solution

4 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)

m@dhu · Answer 1 · 2011-07-20T19:52:00

Solution 1

select top 1 * from tablename order by recorddate desc

Posted 20-Jul-11 19:52pm

m@dhu

Comments

subhash04573 21-Jul-11 2:00am

I have to show only latest record not all records.

RaviRanjanKr 21-Jul-11 2:06am

hey! its will give you only last records. are you not getting SQL query using top 1*. so how its will give you multiple records.

RaviRanjanKr 21-Jul-11 2:07am

If you are looking for something else so please be mention in your Question :)

m@dhu 21-Jul-11 2:47am

Did you try that query gives only one record.

RaviRanjanKr 21-Jul-11 2:02am

Nice Answer, My 5+

m@dhu 21-Jul-11 2:46am

Thanks Ravi.

subhash04573 21-Jul-11 3:44am

sorry for troubling you,
may be i didn't update the question properly.

See the updated question.
In a table i am having some records. out of those records, two records having simillar data but only difference in that two records is Record date.

Now i want to retrive the latest record of those 2 records and following the other records.

Adcvice a query for this.

Ankur^\m/ · Answer 2 · 2011-07-20T19:55:00

Solution 2

You need to sort the results using order by clause. The sort order will be descending as you need the newest at the top. So the query will be like:

SQL

SELECT * FROM TABLE_NAME ORDER BY DATE_COLUMN_NAME DESC

This will give you all the results. Now filter the rows using top clause.

Hope this helps!

Posted 20-Jul-11 19:55pm

Ankur^\m/

Updated 20-Jul-11 19:57pm

v2

Comments

subhash04573 21-Jul-11 2:00am

I have to show only latest record not all records.
Thnks

Ankur^\m/ 21-Jul-11 2:21am

Did I not mention that you can filter the no. of rows using TOP clause?

RaviRanjanKr 21-Jul-11 2:03am

Nice Answer, My 5+

Ankur^\m/ 21-Jul-11 2:21am

Thanks Ravi!

Sugato Pal · Answer 3 · 2011-07-20T20:13:00

Solution 4

Hi Subhash,

Find my query:

select * from tablename where recorddate =(select max(recorddate) from tablename)

This will return only 1 row.I think this will help you.

Cheers

-Sugato

Posted 20-Jul-11 20:13pm

Sugato Pal

Sufi Saint · Answer 4 · 2011-07-20T21:41:00

Solution 5

Do u have any auto increment field???
If so then try

Select * from TableName where Id=(Select Max(Id) from TableName)

Posted 20-Jul-11 21:41pm

Sufi Saint