Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Re: [dtkelly72] DISTINCT SQL Problem

Dec 10, 2002, 11:28 AM
dregs2
User (82 posts)
Dec 10, 2002, 11:28 AM
Views: 17309
Shortcut
Quote Reply
Re: [dtkelly72] DISTINCT SQL Problem In reply to
Hi

try

Select * From t_course

Where ID Not in (

Select Max(ID) From t_course Group By Course, Coursename

Having Count(*) > 1)

Dregs2
Subject Author Views Date
Thread DISTINCT SQL Problem dtkelly72 17689 Dec 9, 2002, 3:49 PM
Post Re: [dtkelly72] DISTINCT SQL Problem 		Alex 17366 Dec 9, 2002, 3:59 PM
Post Re: [dtkelly72] DISTINCT SQL Problem 		Stealth 17342 Dec 9, 2002, 7:29 PM
Post Re: [dtkelly72] DISTINCT SQL Problem 		dregs2 17309 Dec 10, 2002, 11:28 AM