Submitted by zolotoff on Fri, 09/04/2009 - 22:40
Исключение дубликатов
- select distinct
name
from registration
Упорядочивание записей по возрастанию/убыванию/по номеру столбца
- select * from
registration
order by id
- select * from
registration
order by id
desc
- select * from
registration
order by 2
Максимальное/минимальное значение поля
Submitted by zolotoff on Fri, 09/04/2009 - 21:15
SELECT tid, COUNT(nid) FROM <code>term_node</code> WHERE tid IN (1,5,3) GROUP BY tid