mardi 24 février 2015

Wired sql query


sqlite> select sid,max(amount) from(select * from Am where year=2014);
1,600
sqlite> select sid from (select sid,max(amount) from(select * from Am where year=2014));
3


Where 3 come from?! the only option is 1.. Whats going on? Thanks.


Aucun commentaire:

Enregistrer un commentaire