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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Help me ......................A question?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-02 : 09:07:09
Leo Lin writes "helo,everybody

I have a question

Sentence1:
select field1,count(field1) from table where condition =1 group by field1

Sentence2:
select field1,count(field1) from table where condition in (0,1) and condition2 group by field1

Sentence3:
select field1,count(field1)from table where condition =0 group by field1


what can i do to write a Sentence which can give me result which
is the same aoubt there three Sentences.


Best Regard
Leo Lin"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-04-02 : 09:07:09
Is this a homework question?
Go to Top of Page
   

- Advertisement -