I am quite new to sql and I am not sure how to develop this query. I am trying to get the entire record based on a distinct column.
For instance I have a table with about 15 columns in it.
I know select DISTINCT url from table websites will return all the distinct values in the column url. What I need is the entire record. How do you form this query where I get the entire record based on the distinct values of the url column?
Hope this makes sense.