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 |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2010-07-09 : 13:00:10
|
| From what I understand you can't edit a query that has the GROUP BY statement. How can I acheive a grouping without using the GROUP BY. Would a sub-query work? Are sub-queries editable? Here is my data:SONum MiscCode ID0056562 4RIG 1251430056562 4CT 1251440056562 4ROD STRIPPER 1251450056562 4RIG 1257870056562 4CT 125790I would like to 'group by' the MiscCode so the result set would be:SONum MiscCode 0056562 4RIG 0056562 4CT 0056562 4ROD STRIPPER Is there anyway to have a query that doesn't use the GROUP BY to accomplish this? Thanks for any help. |
|
|
jeremy38
Starting Member
2 Posts |
Posted - 2010-07-12 : 01:04:06
|
| What is the query syntax currently? |
 |
|
|
|
|
|
Need help on query