SELECT in SQL

Selecting a Table :

    Query: 
   select * from tablename 

(or)

   select from tablename. 

   example : select * from empdetails . 

Selecting a Table using Where Clause :

   Query: 

   select * from tablename where Columnname1 = value1

(or) 

   select from tablename where Columnname1 = value1

   example : select * from empdetails where empid = 1105