select statement (SQL),”in SQL — queries the database to retreive selected dataGeneral: select “”column1″” [,””column2″”,etc] from “”tablename”” [where “”condition””]; [] = optionalex.select first, last, from empinfo where last LIKE ‘%s’; // selects first and last columns from table (empinfo)// where last name ends with sselect first, last
age from empinfo where last LIKE ‘%illia%’; // selects first last and age columns from empinfo where last name contains illia”