Connecting Tech Pros Worldwide Help | Site Map

How to use not equal to

Newbie
 
Join Date: Aug 2009
Posts: 6
#1: Aug 26 '09
I'm trying to include a not equal to in the following statement so the specified ClientID is not returned.

Expand|Select|Wrap|Line Numbers
  1. SELECT LocationId, ClientID, X, Y, Z, Longitude, Latitude, EntryTime, MAX(EntryTime) as DateTime FROM tmcclientlocation GROUP BY EntryTime
Thanks,

James
mwasif's Avatar
Moderator
 
Join Date: Jul 2006
Location: Pakistan
Posts: 718
#2: Aug 26 '09

re: How to use not equal to


Expand|Select|Wrap|Line Numbers
  1. SELECT LocationId, ClientID, X, Y, Z, Longitude, Latitude, EntryTime, MAX(EntryTime) as DateTime 
  2. FROM tmcclientlocation 
  3. WHERE ClientID <> 10
  4. GROUP BY EntryTime
Reply

Tags
mysql, not equal