Monday, January 12, 2009

SQL Functions

select
 count(*) as 'total users',
 max(id) as 'biggest id',
 min(id) as 'smallest id',
 avg(id) as 'average' 
 from user;