Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tjonas
Starting Member
17 Posts |
 Posted - 2014-11-17 : 09:12:56
|
| I am trying to find the min date in my query but it keeps returning multiple rows for the same code. I am using min(sales_date) and grouping by the other columns. Any ideas on what I can do?sale_id pat_name pat_loc Pat_style pat_code location sales_date1727 Jones, Bob Canton heights shirts 300.01 sales_hx 4/6/2011 0:001727 Jones, Bob Akron zips shoes 300.01 sales_hx 11/9/2013 0:001727 Jones, Bob canfield cans jackets 300.01 sales_hx 9/20/2013 0:001727 Jones, Bob hubbard do jackets 300.01 sales_hx 7/5/2013 0:00 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-17 : 09:16:45
|
| you could post your query! |
 |
|
|
|
|
|
min date