MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

sql-command
Posted by: oliver voegeli
Date: August 08, 2005 03:47AM

hello everybody

I've got a simple tabe:

ID answer (boolean)
1 0
2 1
3 1
4 0
etc.

is it possible to retreive within one sql-command the count of all records with the answer = 0 and the count of all records with the answer = 1?

greetz
oliver

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
sql-command
oliver voegeli
August 08, 2005 03:47AM
Re: sql-command
Felix Geerinckx
August 08, 2005 03:52AM
Re: sql-command
oliver voegeli
August 08, 2005 04:02AM
Re: sql-command
Felix Geerinckx
August 08, 2005 04:08AM
Re: sql-command
oliver voegeli
August 08, 2005 05:24AM
Re: sql-command
oliver voegeli
August 08, 2005 06:30AM
Re: sql-command
Jim Babcock
August 08, 2005 09:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.