Sql question
Posted: Mon Nov 28, 2005 9:30 pm
A table can have several instances of data, one row for each date when its added, like
I want to select one instance of each, the latest (with newest date). The date is represented as 2005-11-29.
Can it be done with one query (with no subqueries)?
Code: Select all
name - size - date
------------------------------
kana - 1 - 1
kana - 2 - 2
kana - 2 - 4
sika - 3 - 2
koira - 1 - 1Can it be done with one query (with no subqueries)?