I saw this code somewhere but I don't quite well understand it...Code:select (select count(*) from locations where url is null) as unprocessed, (select count(*) from locations where url is not null) as processed, (((select processed / (unprocessed + processed)) * 100)) as "% complete";




Reply With Quote