Quote:
Originally posted by sweet7
I don't understand the question. You want to select all the rows from a table with 1 colum different? Do you mean you want to exclude 1 column in your retrieval of information?
|
let's say the columns are: date, name, location
i want retrire all the row with all thre informations (date, name, location) but name shuld not apeare 2 times..
if i use SELECT DISTINCT * FROM TABLE if there are 2 rows with same name but with different dates then they will be displayed
if i use SELECT DISTINCT name, location FROM TABLE then i will not be able to use the informations about date..
can somebody help me with the right sintax, pls?
