Answer to Question #59676 in AJAX | JavaScript | HTML | PHP for joseph

Question

SQL SELECT DISTINCT Syntax
SELECT DISTINCT column_name(s) FROM table_name
SELECT DISTINCT table_name(s) FROM column_name
SELECT column_name(s) FROM table_name DISTINCT
SELECT DISTINCT column_name(s) FROM table_address
2 For numeric values, the correct statement is
SELECT * FROM Persons WHERE Year='1965”
SELECT * FROM Persons WHERE Year=”1965”
SELECT * FROM Persons WHERE Year='1965'
SELECT * FROM Persons WHERE Year=1965

Answer 1

1) SELECT DISTINCT column_name(s) FROM table_name
(https://www.w3schools.com/sql/sql_distinct.asp )
2) SELECT * FROM Persons WHERE Year=1965
(https://www.w3schools.com/sql/sql_where.asp )