al4629740
asked on
Need to select two distinct columns in my recordset
I have one table named AttendanceGrid:
Here are an example of the data and column names
Name Activity Start Stop Month Notes
Bobby Tennis 12:00pm 2:00pm January None
Timmy Tennis 12:00pm 2:00pm February None
Joyce Tennis 1:00pm 3:00pm February None
Dennis Tennis 12:00pm 2:00pm January None
Sue Tennis 1:00pm 3:00pm January None
Bart Soccer 12:00pm 2:00pm January None
I would like to select Distinct Activity records associated with the Start and Stop Time. For example if I selected distinct Activity associated with Start and Stop times I should be able to pull up the following:
Tennis 12:00pm 2:00pm
Tennis 1:00pm 3:00pm
Soccer 12:00pm 2:00pm
How can I write an SQL statement to do that? I am quite novice to SQL code
Here are an example of the data and column names
Name Activity Start Stop Month Notes
Bobby Tennis 12:00pm 2:00pm January None
Timmy Tennis 12:00pm 2:00pm February None
Joyce Tennis 1:00pm 3:00pm February None
Dennis Tennis 12:00pm 2:00pm January None
Sue Tennis 1:00pm 3:00pm January None
Bart Soccer 12:00pm 2:00pm January None
I would like to select Distinct Activity records associated with the Start and Stop Time. For example if I selected distinct Activity associated with Start and Stop times I should be able to pull up the following:
Tennis 12:00pm 2:00pm
Tennis 1:00pm 3:00pm
Soccer 12:00pm 2:00pm
How can I write an SQL statement to do that? I am quite novice to SQL code
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
max which is an aggregate function.
ASKER
what does it do?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER