TalkPHP - View Single Post - The art of sub-selects

bluesaga · 09-07-2007, 02:25 PM

Thanks for the kind words Karl.

And thanks for the typo-catch Adam!

However for your peice of code, why wouldn't you just do:

Code:

SELECT
      count(*) as count
FROM
      myTable
HAVING
      count > 1

More efficient than loading the variable into memory.

09-07-2007, 02:25 PM	#4 (permalink)
bluesaga Super Moderator Join Date: Sep 2007 Posts: 165 Thanks: 0	Thanks for the kind words Karl. And thanks for the typo-catch Adam! However for your peice of code, why wouldn't you just do: Code: SELECT count(*) as count FROM myTable HAVING count > 1 More efficient than loading the variable into memory.