SELECT COUNT(colname) AS aliasname FROM tablename