Hello.
Yes. For example:
mysql> select count(*) from yo group by a order by a desc;
+--+
| count(*) |
+--+
|6 |
| 12 |
|3 |
+--+
3 rows in set (0.00 sec)
mysql> select count(*) from yo group by a order by a asc;
+--+
| count(*
hello,
can we give the same field name in group by and order by ?
Eg. select count(*) from table group by filedname1 orderby filedname1
desc;
=
kavi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]