List:General Discussion« Previous MessageNext Message »
From:samk Date:April 18 2008 4:39am
Subject:A SQL Query Question
View as plain text  
See Thread at: Posted on behalf of a User

Hello everyone,

I have a table A:

userId long
picture MeduimBlob
datePosted DateTime

A userId can have many pictures posted. I want to write a query that returns a distinct
userId along with the most recent picture posted. Can someone suggest an elegant and fast
query to accomplish this?



A SQL Query Questionsamk18 Apr
  • Re: A SQL Query QuestionPeter Brawley18 Apr
Re: A SQL Query Questionsamk18 Apr