MySql

MySql Tutorial-Sql Select Distinct

There may be duplicate values in column of table.But we may want to only distinct values from that column. This kind of requirement is fulfilled by DISTINCT. Syntax is as: SELECT DISTINCT(column_name) FROM table_name ...



READ MORE...


MySql Tutorial-Sql Min function

The MIN function is used to get minimum value in column. Syntax is as: SELECT MIN(column_name) FROM table_name As in example we have table employees id first_name last_name ...



READ MORE...


MySql Tutorial-Sql Max function

The MAX function is used to get maximum value of column. Syntax is as: SELECT MAX(column_name) FROM table_name As in example we have table employees id first_name last_name ...



READ MORE...


MySql Tutorial-Sql Count function

The COUNT function is used to count number of records in table. Syntax is as: SELECT COUNT(*) FROM table_name As in example we have table employees id first_name last_name ...



READ MORE...


MySql Tutorial-Sql SUM function

The SUM function is used to calculate sum of values of a column. Syntax is as: SELECT SUM(column_name) FROM table_name As in example we have table employees id first_name last_name ...



READ MORE...


MySql Tutorial-Sql AVG function

The AVG function is used to calculate average of values of a column. Syntax is as: SELECT AVG(column_name) FROM table_name As in example we have table employees id first_name last_name ...



READ MORE...


MySql Tutorial-Sql order by

The ORDER BY keyword is used to get data order wise. Data can be arranged in ascending or descending order Syntax is as: SELECT * FROM table_name WHERE [ column_name condition ] ORDER BY column_name [ASC|DESC] ASC is used for ascending order ...



READ MORE...


MySql Tutorial-Sql Like operator

The LIKE operator is used to compare similar values using wildcard operators.Wildcard operators are the percent sign ( % ) and the underscore ( _ ). The percent sign ( % ) represents multiple characters whereas the underscore ( _ ) represents singl ...



READ MORE...


MySql Tutorial-Sql Between operator

The BETWEEN operator is used to select values within range of values in the parenthesis with values separated by AND operator. Syntax is as: SELECT * FROM table_name WHERE column_name BETWEEN 'value1' AND 'value2' As in example we have ...



READ MORE...


MySql Tutorial-SQL IN operator

The IN operator is used to compare one or more values given in list of values in the parenthesis with each values separated by comma. Syntax is as: SELECT * FROM table_name WHERE column_name IN ('value1','value2','value3',...) As in ex ...



READ MORE...