Re: [sqlite] select statement - Need help

2009-03-08 Thread Igor Tandetnik
"Joanne Pham" wrote in message news:936179.87380...@web90307.mail.mud.yahoo.com > I have the folowing table which has the following data for example: > remoteId hostName lastUpdateTime > > So if I ran this statement below: > select * from table group by hostName having count(*) > 1; > I got t

Re: [sqlite] select statement - Need help

2009-03-08 Thread Joanne Pham
eed help It gave me the syntax error! JP From: "Adler, Eliedaat" To: General Discussion of SQLite Database Sent: Sunday, March 8, 2009 1:08:51 PM Subject: Re: [sqlite] select statement - Need help By side-effect the following statement should give

Re: [sqlite] select statement - Need help

2009-03-08 Thread Joanne Pham
It gave me the syntax error! JP From: "Adler, Eliedaat" To: General Discussion of SQLite Database Sent: Sunday, March 8, 2009 1:08:51 PM Subject: Re: [sqlite] select statement - Need help By side-effect the following statement should give th

Re: [sqlite] select statement - Need help

2009-03-08 Thread Adler, Eliedaat
te.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joanne Pham Sent: Sunday, March 08, 2009 9:45 PM To: General Discussion of SQLite Database Subject: [sqlite] select statement - Need help Hi All, I have the folowing table which has the following data for example: remoteId ho

[sqlite] select statement - Need help

2009-03-08 Thread Joanne Pham
Hi All, I have the folowing table which has the following data for example:     remoteId hostName        lastUpdateTime     1        host1    19     2   host111     3host2    22