Distinct for only one column
586646Jul 5 2007 — edited Jul 6 2007Hi,
I want select only distinct column of one column while at the same time displaying the other column attributed to the selected column.
e.g. select name
from student
where name in
(select distinct name from student)
and processing_date >= '20070701'
and processing_date < '20070702'
this list all the similar rows and the distinct. Please assist. Thanks