Back to General and Gameplay Programming

[web] sql question

General and Gameplay Programming Programming

Started by unknownProdigy June 09, 2006 01:13 AM

1 comment, last by unknownProdigy 17 years, 10 months ago

unknownProdigy

160

Author

June 09, 2006 01:13 AM

I'm trying to make a table 'sometable' that has two columns: 'categoryid' and 'dateadded'. 'categoryid' is a foreign key to another table and 'dateadded' refers to a date object. Suppose that for each 'categoryid' value in the table, I want to get the lastest date only. How would you query that?

Advertisement

UncleRemus

313

June 09, 2006 01:37 AM

Hello,

Perhaps this might work :

select categoryid max(dateadded) from table
group by categoryid

kind regards
Uncle Remus

unknownProdigy

160

Author

June 09, 2006 01:45 AM

thanks a whole lot

This topic is closed to new replies.

Advertisement

Popular Topics

Aybe One

How do you manage yourself and your time as years pass on? GDNet Lounge

Jikoob

Too many managers? General and Gameplay Programming

The promise of freedom in story games Game Design and Theory

robertrobert

Facebook Ads for sales on steam, does it work? Games Business and Law

gjl

New Generated Constructor & JIT Issue AngelCode

MrK45

Inheriting from application registered class AngelCode

Advertisement

Recommended Tutorials

stitchs_login

Getting into Games through Education: Preparing for Interview Career Development

Myopic Rhino

OpenGL Frame Buffer Object 101 Graphics and GPU Programming

jsaade

DigiPen Academy - Introduction to Game Design Lessons - Using Scratch Game Design and Theory

Myopic Rhino

Frame Rate Independent Movement General and Gameplay Programming

Myopic Rhino

A Tutorial on Pointers and Arrays in C General and Gameplay Programming