Prepared Statements

Question

I have only found examples with INSERT. How do you SELECT ??
but not a simple select
using prepared statement

Answer 1

Select * From Table_Name -- want to see all columns
Select Column_Name(s) from Table_Name -- if you want to see more than single column, you must use comma (,) between all columns

Eg
Select * from Employee
Select Emp_No, Emp_name, Emp_DOB from Employee

Answer 2

SELECT FROM table name WHERE conditions =...

Eg

SELECT FROM people WHERE s/n=1