sqlite> create table t1(n,c);
sqlite> insert into t1 values("a",3);
sqlite> insert into t1 values("a",5);
sqlite> insert into t1 values("b",7);
sqlite> insert into t1 values("b",2);
sqlite> select * from t1;
a|3
a|5
b|7
b|2
sqlite> select n,max(c) from t1 group by n;
a|5
b|7-- [image: Just A Little Bit Of Geekness]<http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1> Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza. (Larry Wall). On Fri, Jun 6, 2008 at 11:03 AM, Andrea Galligani < [EMAIL PROTECTED]> wrote: > Hi to all, > > I'm a novice in SQL and SQLite so I apologize if this question has an > obvious solution > > I have a table formed in this way. > > NAME SCORE INFO1 INFO2 etc. > Andrew 5 aaa bbb ... > Andrew 8 ddd eee ... > Paul 4 xxx yyy ... > Paul 6 aaa fff ... > > I need a query to get from any name the row with the max score. So from > the above sample, I would like to obtain the following rows. > > NAME SCORE INFO1 INFO2 etc. > Andrew 8 ddd eee ... > Paul 6 aaa fff ... > > Can I get this result using a complex query or should I filter the rows > using any different tool from SQL (C/C++)? > > Thanks in advance > Andrea > > -- > -------------------------------------- > Andrea Galligani > > Macs Tech s.r.l. > Via San Paolo 11, 56125 > Pisa - Italy > > Phone...: +39 050 40915 > e-mail..: [EMAIL PROTECTED] > -------------------------------------- > > _______________________________________________ > 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
