Re: How to get it in ONE query?

2001-04-12 Thread Jan Dvorak
do this in these 2 queries. > |-----------------------| > |How to get it in ONE query?| > |---| > 1) > mysql> SELECT count(*) FROM t_what WHERE price<25; > +--+ > | count(*) | > +--+ > | 25 | > +--+ > 1 row

Re: How to get it in ONE query?

2001-04-11 Thread Gerald Clark
: > > I need to get information about number of all rows produced by query 1) > and information produced by limited query 2). > I can do this in these 2 queries. > |-----------| > |How to get it in ONE query?| > |---| > 1) > mysql>

How to get it in ONE query?

2001-04-11 Thread michalm
I need to get information about number of all rows produced by query 1) and information produced by limited query 2). I can do this in these 2 queries. |---| |How to get it in ONE query?| |---| 1) mysql> SELECT count(*) FROM t_what WHERE pr