SQL

Question 1

How do you select all columns from a table?

Answer 1

SELECT * FROM tablename;

Question 2

How do you prevent duplicate records when SELECTing?

Answer 2

Use the DISTINCT keyword

e.g. SELECT DISTRINCT category FROM video;