sers-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of YAN HONG YE
> Sent: Friday, 15 June, 2012 03:57
> To: sqlite-users@sqlite.org
> Subject: [sqlite] order by clause should come after union not before
>
> select * from hbc order by cmc desc limit 10
YAN HONG YE 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
select * from hbc where rowid in (select rowid from hbc order
On Fri, Jun 15, 2012 at 08:10:20AM -0400, Kevin Benson scratched on the wall:
> On Fri, Jun 15, 2012 at 5:56 AM, YAN HONG YE 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 ca
On Fri, Jun 15, 2012 at 5:56 AM, YAN HONG YE 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/lan
On 15 Jun 2012, at 10:56am, YAN HONG YE 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
Yes. The UNION clauses you're
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
___
sqlite-users mailing list
sqlite-users@sqlite.or
6 matches
Mail list logo