General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
Don't know what I would do without UT's help.
I have a table with part number, status, datestamp fields. There can be several records of each part number.
I need to know how many records have a ststus of 2 by part number with highest date stamp. I see the need to group by part number in date stamp order, take the latest date and see if the status is 2 and get a total count of these.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only