________________________________
From: Joanne Pham <joannekp...@yahoo.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Tuesday, February 17, 2009 10:14:54 PM
Subject: [sqlite] (no subject)
Hi All,
I have the select statement as below
sqlite> select remoteId, hostName , remoteWXType from remoteWXTable order by
hostName;
and the output is below:
1|HostName1-T432|2
2|HostName2-T421|2
3|HostName3-XP|2
4|HostName3-XP|2
But I would like the sql statement to return as below:
(HostName3 has two remoteId so I want to return as one row but two different
remoteId as below)
1|HostName1-T432|2
2|HostName2-T421|2
3,4|HostName3-XP|2
Can you please help to change the sql statement to return the above result set.
Thanks,
JP
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
