group by in sql
snippet in sql

sql order by

user7934

 //this_for_descending_order.. 
 SELECT * FROM TableName ORDER BY columnName DESC;
 // this_for_ascending_order..
SELECT * FROM TableName ORDER BY columnName ASC;

sql group by

user8734

# Say you have a table called SALARIES that contains a 
# few duplicate NAME entries...
+----+-------------+--------+
| ID |    NAME     | SALARY |
+----+-------------+--------+
| 1	 |     Bob     |  500   |
| 2  |    Alice    |  500   |
| 3  |    Alice    |  200   |
| 4  |    Frank    |  700   |
| 5  |    Percy    |  100   |
| 6  |    Percy    |  800   |
| 7  |   Cyrille   |  400   |
+----+-------------+--------+

# We can obtain the total salaries of each person
# by using GROUP BY in the following query...
SELECT NAME, SALARY FROM SALARIES GROUP BY NAME;

# Which will output the following...
+------------+--------+
|   Alice    |  700   |
|    Bob     |  500   |
|  Cyrille   |  400   |
|   Frank    |  700   |
|   Percy    |  900   |
+------------+--------+

sql group by

user4433

  SELECT column_name(s)
  FROM table_name
  WHERE condition
  GROUP BY column_name(s)
  HAVING condition
  ORDER BY column_name(s); 

MySQL GROUP BY

user4859

SELECT 
    c1, c2,..., cn, aggregate_function(ci)
FROM
    table
WHERE
    where_conditions
GROUP BY c1 , c2,...,cn;

group by in sql

user5915


  SELECT column_name(s)

  FROM table_name

  WHERE condition

  GROUP BY column_name(s)
ORDER BY column_name(s);

 

group by in sql

user4932

GROUP BY: is used to collaborate
with the SELECT statement to arrange 
matching data into groups.

ORDER BY: is for sorting result
either in descending or ascending order.