On Fri, Jun 15, 2012 at 5:56 AM, YAN HONG YE <yanhong...@mpsa.com> wrote: > > select * from hbc order by cmc desc limit 10 > union > select * from hbc where qph>0 > union > select * from hbc where hctl=1 > > this sql cmd cause the error: > order by clause should come after union not before >
http://www.sqlite.org/lang_select.html ORDER BY and LIMIT clauses may only occur at the end of the entire compound SELECT. -- -- -- --Ô¿Ô-- K e V i N _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users