MySQL Forums
Forum List  »  New in 4.1: Subqueries

Advanced Search
New Topic

Re: count columns
Posted by: john miller
Date: March 14, 2005 10:14AM

select id, count(*) from table group by id

or

select count(*) from table where id = 1

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


Subject
Views
Written By
Posted
count columns
13504
Adamo Tsolis
March 11, 2005 05:46AM
Re: count columns
6056
john miller
March 14, 2005 10:14AM


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.