about summary refs log tree commit diff
path: root/users/aspen/emacs.d/snippets/sql-mode/count(*) group by
diff options
context:
space:
mode:
Diffstat (limited to 'users/aspen/emacs.d/snippets/sql-mode/count(*) group by')
-rw-r--r--users/aspen/emacs.d/snippets/sql-mode/count(*) group by5
1 files changed, 5 insertions, 0 deletions
diff --git a/users/aspen/emacs.d/snippets/sql-mode/count(*) group by b/users/aspen/emacs.d/snippets/sql-mode/count(*) group by
new file mode 100644
index 0000000000..6acc46ff39
--- /dev/null
+++ b/users/aspen/emacs.d/snippets/sql-mode/count(*) group by
@@ -0,0 +1,5 @@
+# -*- mode: snippet -*-
+# name: count(*) group by
+# key: countby
+# --
+SELECT count(*), ${1:column} FROM ${2:table} GROUP BY $1;