Can you elaborate on exactly what information you are trying to retrieve? If you do not include the id in your query, you will get a distinct list of titles. However, you want to know the ID of each distinct title. So, if you add in the ID column in your query, you will get that information.
I am not clear on what you are trying to get in your results.
I'm trying to get the id of the distinct elements. if i say
SELECT id, DISTINCT title FROM songs WHERE lang = 'Telugu'
Its showing all the records from the table. I want only id's of the perticular distinct titles. Please help me