How to select multiple latest records with different latest dates - DML (SELECT, INSERT, UPDATE, DELETE) Questions

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » How to select multiple latest records with different latest dates

How to select multiple latest records with different latest dates

Options

Previous Topic · Next Topic

jag17

Posted: Sunday, January 27, 2008 4:21:30 AM

Rank: Newbie

Joined: 1/27/2008
Posts: 2
Points: 6
Location: SG

Hi

I am just starting out on sql programming.

I have one table with three columns

Item Name | Price |Date
Item1 | 44 |25-Jan-08
Item1 | 45 |26-Jan-08
Item1 | 43 |27-Jan-08
Item2 | 21 |26-Jan-08
Item2 | 34 |28-Jan-08
Item3 | 91 |27-Jan-08
Item3 | 98 |29-Jan-08

I want to pick latest price of all items and produce a result as below

Item1 | 43 |27-Jan-08
Item2 | 34 |28-Jan-08
Item3 | 98 |29-Jan-08

Please help me on this

Thank You
-Jag

Scott Whigham

Posted: Monday, January 28, 2008 11:39:27 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

You'll need a subquery for this:

SELECT * FROM MyTable main
WHERE Date = (SELECT MAX(Date) FROM MyTable sub WHERE sub.Item = main.Item)

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.