----- Original Message ----- From: "Tim McDaniel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 04, 2004 11:23 PM Subject: [sqlite] SQL help
> Given a table T like this: > A B > --------- > 1 5 > 2 5 > 3 5 > > I need a query to give me just the row with the largest A value, within > a group defined by B. In this case, it would be the row with A = 3. SELECT MAX(A) AS A , B FROM T GROUP BY B Lawrence --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.772 / Virus Database: 519 - Release Date: 01/10/04