Tutorial by Examples

SELECT is used to retrieve rows of data from a table. You can specify which columns will be retrieved: SELECT Name, Position FROM Employees; Or just use * to get all columns: SELECT * FROM Employees;

This query will return all columns from the table sales where the values in the column amount is greater than 10 and the data in the region column in "US". SELECT * FROM sales WHERE amount > 10 AND region = "US" You can use regular expressions to select the columns you wan...

Sample table (say Employee) structure Column NameDatatypeIDINTF_NameSTRINGL_NameSTRINGPhoneSTRINGAddressSTRING Project all the columns Use wild card * to project all the columns. e.g. Select * from Employee Project selected columns (say ID, Name) Use name of columns in the projection list. e...