ST Alpha - "I need some SQL help if anyone cares to take a look" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 156

I need some SQL help if anyone cares to take a look

Posted by JaxSean (aka JaxSean) Jun 26 '09, 11:26

I have a weird table that has lots of similar data, like:

num | amount | type | date | name | ID
1 | $100 | D | 2009-06-01 | smith | 555
5 | $500 | D | 2009-06-05 | jones | 321
6 | $100 | D | 2009-06-06 | smith | 555

how do I query to only bring up the 'most recent' of each ID? I want to bring up all ID's, but only the most recent of each?

I think I'm overthinking this.

Responses:

Dammit, all this stuff is on my work computer. - Will Hunting Jun 26, 11:33
something like Max(ID) might/should work I think -- nm - Mel Profit Jun 26, 11:30 2
- I think MAX is only for Group By clauses. - JaxSean Jun 26, 11:34
- that doesn't work for entire rows, though, only individual aggregated fields. -- nm - Beryllium Jun 26, 11:30
No, you're not overthinking it. Dealing with that always annoys me. - Beryllium Jun 26, 11:30 2
- Yeah, that was the route I was thinking. My brain is full, I think. - JaxSean Jun 26, 11:33 1
  - I concur completely. Here's something that might be close to what you need, - Beryllium Jun 26, 11:36

Post a message top

I need some SQL help if anyone cares to take a look

Replies are disabled on threads older than 7 days.