List:General Discussion« Previous MessageNext Message »
From:Rob Desbois Date:September 27 2006 1:48pm
Subject:re: Count of children
View as plain text  
Your sentence 'I want the count of all sub-entries for a specific entry' converts straight
into SQL:

'I want'
    SELECT
the count of all entries
    COUNT(*) FROM myTable
with a specific parent
    WHERE parent_id = 5

You've missed one of the major benefits of SQL - it's designed to read like an English
sentence!
--Rob


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________
Thread
Count of childrenAndré Hänsel27 Sep
  • Re: Count of childrenjoao27 Sep
  • re: Count of childrenRob Desbois27 Sep
    • AW: Count of childrenAndré Hänsel27 Sep
    • Re: Count of childrenjoao27 Sep
      • Re: Count of childrenDouglas Sims27 Sep
  • Re: Count of childrenPeter Brawley27 Sep
    • AW: Count of childrenAndré Hänsel27 Sep
      • Re: AW: Count of childrenddevaudreuil27 Sep
      • Re: AW: Count of childrenPeter Brawley27 Sep
        • RE: AW: Count of childrenRobert DiFalco27 Sep