What do you want to save?
Add Code snippet
New code examples in category SQL
-
Jen Denise 2021-08-27 11:16:01
oracle comment on view
COMMENT ON TABLE view_name IS 'A view comment'; COMMENT ON COLUMN view_name.MY_COLUMN IS 'A column comment'; SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'VIEW_NAME'; SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'VIEW_NAME'; Add solution -
Alex1014 2021-08-27 08:25:01
psql drop column
ALTER TABLE table_name DROP COLUMN column_name; Add solution -
-
Syl 2021-08-27 06:04:02
what is having clause
HAVING clause in SQL is used to filter records in combination with the GROUP BY clause. It is different from WHERE, since WHERE clause cannot filter aggregated records. HAVING is a column operation. Select department_id, Min (Salary) From Employees Gro... Add solution