How do you select and insert queries in SQL?

Generally you can say using SELECT query like below

  1. SELECT * FROM TableName

for selection operation

And INSERT query like

  1. INSERT TableName (Column1,Column2,…)

  2. VALUES (value1,value2,…)

for insert operations

But depending on the type of product you use (SQLServer, MySQL, PostGRESQL etc) there may be slight syntax changes in some cases