Home >> SQL >> COUNT(*) aggregate function in SQL

COUNT(*) aggregate function in SQL

Find Number of rows in the table including duplicate and those NULL.

Example

SELECT count(*) AS total FROM employee

Post Your Comment

Next Questions
AVG() aggregate function
MIN() aggregate function
MAX() aggregate function
SUM() aggregate function
STDED() aggregate function
CONCAT() function
GROUP_CONCAT() function
CONCAT_WS() function
CHECKSUM_AGG() aggregate function
ABS(n) aggregate function
POWER(m,n) aggregate function
ROUND() aggregate function
SQRT() aggregate function
LEAST() aggregate function
EXP() aggregate function
EXTRACT() aggregate function
MOD() aggregate function
TRUNC() aggregate function
FLOOR() aggregate function
CEIL() aggregate function
FIRST() aggregate function
LAST() aggregate function
MID() aggregate function
LEN() aggregate function
NOW() aggregate function

Copyright ©2022 coderraj.com. All Rights Reserved.