Loading [MathJax]/extensions/TeX/AMSsymbols.js
What does the numbers in the SQL clause “GROUP BY 1” mean?
SELECT
account_id, open_emp_id ^^^^ ^^^^
1
2
FROM
account
GROUP
BY
1
;
GROUP BY 1 refers to the first column in select statement which is account_id.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment