Thread: count question
View Single Post
Old 02-22-2013, 06:29 PM   PM User | #6
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,210
Thanks: 59
Thanked 3,996 Times in 3,965 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
Quote:
Originally Posted by Indor View Post
Try this,
Select count(*) from Table where Employ Name="ABCD";
i hope this will help you out
** WRONG ANSWER **

Aside from the fact that it is irrelevant to what he is asking, that code is illegal and will cause a SQL error.
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is offline   Reply With Quote