Hi all,I'm not very profecient at SQL although I do have strong programming background, however I am finding it quite difficult trying to create a SQL query to return the results that I need.I have a database that has several columns. I am trying to select all the rows from the last date entered for each partnumber.Sample tableId, Partnumber, date_entered, quantity, yadda, yadda210, part1, 130310, 100, xxx, yyy11, part2, 130310, 50, xxx, yyy12, part1, 130517, 20, xxx, yyy13, part1, 130516, 500, xxx, yyy14, part1, 130517, 30, xxx, yyy
What I would like returned isId, Partnumber, date_entered, quantity, yadda, yadda212, part1, 130517, 20, xxx, yyy14, part1, 130517, 30, xxx, yyy11, part2, 130310, 50, xxx, yyy
So I want to get all the rows with MAX(date_entered) for each partnumber.Any help is appreciated in creating a SQL query for this.ThanksIan