Advertisement
TDCustmerSupportJP

Untitled

Jul 10th, 2017
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.30 KB | None | 0 0
  1. SELECT
  2.  COUNT(1)         AS cnt1,
  3.  COUNT(*)         AS cnt2,
  4.  COUNT(member_id) AS cnt3,
  5.  COUNT('hoge')    AS cnt4,
  6.  COUNT(TRUE)      AS cnt5,
  7.  COUNT(FALSE)     AS cnt6,
  8.  COUNT(0)         AS cnt7,
  9.  COUNT(NULL)      AS cnt8
  10. FROM sales_slip
  11. WHERE TD_TIME_RANGE(time, '2006-05-01', '2006-06-01','JST')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement