Why you don't use GROUP BY?
- Original Message -
From: Siim Einfeldt aka Itpunk <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 1:59 PM
Subject: problems getting DISTINCT data
>
>
> SELECT DISTINCT estitle,id,lepingid FROM main
SELECT DISTINCT estitle,id,lepingid FROM main WHERE litsents='something'
ORDER BY lepingid
Now, lets suppose I have 20 entries with the exact same information (or at
least estitle and lepingid are the same). What if I wanted to get only one
entry with the same information? I could do it with LI