Answers

Question and Answer:

  Home  SQL and PL/SQL

⟩ SELECT statements in SQL?

SELECT column_name(s) FROM table_name

SELECT DISTINCT column_name(s) FROM table_name

SELECT column FROM table WHERE column operator value

SELECT column FROM table WHERE column LIKE pattern

SELECT column,SUM(column) FROM table GROUP BY column

SELECT column,SUM(column) FROM table GROUP BY column HAVING SUM(column) condition value

Note that single quotes around text values and numeric values should not be enclosed in quotes. Double quotes may be acceptable in some databases.

 125 views

More Questions for you: