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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2002-04-02 : 09:07:09
|
| Leo Lin writes "helo,everybodyI have a questionSentence1:select field1,count(field1) from table where condition =1 group by field1Sentence2:select field1,count(field1) from table where condition in (0,1) and condition2 group by field1Sentence3:select field1,count(field1)from table where condition =0 group by field1what can i do to write a Sentence which can give me result whichis the same aoubt there three Sentences.Best RegardLeo Lin" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-04-02 : 09:07:09
|
| Is this a homework question? |
 |
|
|
|
|
|