-
Distinct Row Query
I need help with a query on a single table.
The table in name, date, ss# and I need to get unique rows, but there can me many ss# to each date. I need to get the max date for each unique ss#.
Select distinct name, date, ss#
returns all rows, because dates are different, but I need to have the results contain all three columns of information.
Thanks for the help,
-Ken
-
Distinct Row Query (reply)
select ssn#, max(<your date field>)
from <table name>
group by ssn#
------------
ken at 6/18/99 4:03:24 PM
I need help with a query on a single table.
The table in name, date, ss# and I need to get unique rows, but there can me many ss# to each date. I need to get the max date for each unique ss#.
Select distinct name, date, ss#
returns all rows, because dates are different, but I need to have the results contain all three columns of information.
Thanks for the help,
-Ken
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|