| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Group By in SQL
need to add a 'select' & 'Group by' statement in excel query.
The Spreadsheet looks like this KRE001 8/17/2007 KRE001 8/17/2007 WAT001 9/27/2007 WAT001 9/27/2007 TOT001 7/6/2007 KEM001 7/12/2007 CYC001 7/16/2007 CYC001 7/16/2007 MET007 7/16/2007 This is the sql statement. SELECT V_PO_HISTORY.VENDOR, V_PO_HISTORY.DATE_PO FROM V_PO_HISTORY V_PO_HISTORY WHERE (V_PO_HISTORY.DATE_PO{d '2007-07-01'}) I need to group the vendors in column A. can someone please help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Group By in SQL
You need a total field of some kind... the only thing I can think of
is count of date? SELECT V_PO_HISTORY.VENDOR, Count(V_PO_HISTORY.DATE_PO) AS MyCount FROM V_PO_HISTORY GROUP BY V_PO_HISTORY.VENDOR; Perhaps you mean consolidating unique records? In which case, use the DISTINCT keyword: SELECT DISTINCT V_PO_HISTORY.VENDOR, V_PO_HISTORY.DATE_PO FROM V_PO_HISTORY; On Feb 11, 9:23 am, Francis wrote: need to add a 'select' & 'Group by' statement in excel query. The Spreadsheet looks like this KRE001 8/17/2007 KRE001 8/17/2007 WAT001 9/27/2007 WAT001 9/27/2007 TOT001 7/6/2007 KEM001 7/12/2007 CYC001 7/16/2007 CYC001 7/16/2007 MET007 7/16/2007 This is the sql statement. SELECT V_PO_HISTORY.VENDOR, V_PO_HISTORY.DATE_PO FROM V_PO_HISTORY V_PO_HISTORY WHERE (V_PO_HISTORY.DATE_PO{d '2007-07-01'}) I need to group the vendors in column A. can someone please help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Group By in SQL
SELECT DISTINCT works in this case. Thank you very much.
"ilia" wrote: You need a total field of some kind... the only thing I can think of is count of date? SELECT V_PO_HISTORY.VENDOR, Count(V_PO_HISTORY.DATE_PO) AS MyCount FROM V_PO_HISTORY GROUP BY V_PO_HISTORY.VENDOR; Perhaps you mean consolidating unique records? In which case, use the DISTINCT keyword: SELECT DISTINCT V_PO_HISTORY.VENDOR, V_PO_HISTORY.DATE_PO FROM V_PO_HISTORY; On Feb 11, 9:23 am, Francis wrote: need to add a 'select' & 'Group by' statement in excel query. The Spreadsheet looks like this KRE001 8/17/2007 KRE001 8/17/2007 WAT001 9/27/2007 WAT001 9/27/2007 TOT001 7/6/2007 KEM001 7/12/2007 CYC001 7/16/2007 CYC001 7/16/2007 MET007 7/16/2007 This is the sql statement. SELECT V_PO_HISTORY.VENDOR, V_PO_HISTORY.DATE_PO FROM V_PO_HISTORY V_PO_HISTORY WHERE (V_PO_HISTORY.DATE_PO{d '2007-07-01'}) I need to group the vendors in column A. can someone please help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
| I wish to group my worksheets under group tabs | Excel Worksheet Functions | |||
| How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
| Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
| How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Linear Mode
