Database Tutorials | Free Database Tutorials | Free online Database Tutorials

Database 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...


Database 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...


Database Tutorial-sql and or query-sql and or operators

As in have learnt about Where Clause with single condition. But there is not always single condition, most of the time we use multiple conditions while selecting data from table. For applying multiple conditions we use AND OR with Where clause. The ...



READ MORE...


Database Tutorial-sql where clause and condition

Always we don't want all records from table. So selecting required records, we use WHERE clause. Here is syntax: SELECT col_name1,col_name2 FROM table_name WHERE "condtion" Suppose we have table with name employees ...



READ MORE...


Database Tutorial-Select query in mysql

Select command is used to fetch the rows from one or more tables. The most comman and useful command is as : Select * from table_name Above command retrieve all rows and columns of a table.The star sign (*) is used to select all column ...



READ MORE...


Database Tutorial-Sql server date function

As in article Sql Server dateparts values and abbreviations we have learnt about dateparts in sql server. Now In this  article we will learn manipulation of datetime values with date functions. Date functions can be used in then column_list, the ...



READ MORE...