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 |
|
real_pearl
Posting Yak Master
106 Posts |
 Posted - 2004-07-20 : 04:52:46
|
| Wafer Bin X YX123 Bin1 1 32X123 Bin1 1 33X123 Bin1 1 34X124 Bin1 1 32X124 Bin1 1 33X124 Bin1 1 34How I may write a query returning the COUNT of BIN for a particular X, Y position. I meanBin Count for Bin1 on X, Y (1,32) should be 2 as Bin1 Lies on the same coordinates in two different wafers. Please guide me how to write the query |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-07-20 : 05:03:26
|
| select bin,x,y,count(*) as numfrom tablegroup by bin,x,yCiaO*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-07-20 : 09:03:45
|
| select x,y, count(*)from tablegroup by x,y |
|
|
|
|
|
|
Query Problem