Jump to content

[SOLVED] Doubt with a Select


rantsh

Recommended Posts

someone at the mysql forum posted a reply to this same Q (I asked both here and there)

 

the reply was

select
count(column1) allrows,
count case when column1>0 then 1 else null end as somerows
from yourtablename

 

Has someone tried this out before? I'll try in a while and let you know though

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.