Count no. of rows added last hours Mysql

Count numbers of rows added last hours Mysql

SELECT 
  COUNT(*) AS cnt 
FROM
  `user` `ur` 
WHERE ur.added_time >= DATE_SUB(NOW(), INTERVAL 1 HOUR);

SELECT DATE_SUB(NOW(), INTERVAL 1 HOUR);

Output
count


Pankaj Singh Sugara