Dear All,
I'm facing a problem when using DISTINCT in mysql. Please refer my database design below.
id lang album singer title family writer song hits
In my db i want distinct title and the id from the db.
I'm trying the following code. But it only fetching the results but not the id. If i try its again displaying all the records.
Now i'm trying to display the results using query
SELECT DISTINCT `title` FROM `songs` WHERE `lang` = 'Telugu'
If i try this
SELECT id
, DISTINCT title
FROM songs
WHERE lang
= 'Telugu'
I'm getting nothing from the db.
Please help me which this. Thanks in advance.