Sqltutorial - sqltutorial.co
General Information:
Latest News:
SQL INSERT INTO Statement 7 Aug 2011 | 08:38 pm
SQL INSERT INTO Statement This command is used for adding of new rows into a database table or tables created of a sigh. SQL INSERT INTO Syntax: The INSERT command can be used in two ways: INSERT INTO...
SQL ORDER BY clause 7 Aug 2011 | 07:42 pm
SQL ORDER BY The ORDER BY clause will help you sort the returned query disabled registration depending on one or more columns. Through the keywords ASC and DESC specify if sorting will be done in asce...
SQL AND – OR Operators 7 Aug 2011 | 07:14 pm
SQL AND – OR Operators And – it means that both expressions between which is the operator must be true for the operator to return TRUE. If any of them is false, AND will return FALSE. Or – if any of t...
SQL WHERE Clause 7 Aug 2011 | 06:25 pm
SQL WHERE Clause The condition in the WHERE clause is a Boolean expression formed by combining simple predicate operators AND, OR and NOT. Each uses simple predicate comparison operators (=,>,> =, <,...
SQL SELECT DISTINCT Statement 7 Aug 2011 | 05:52 pm
SQL SELECT DISTINCT Statement In a table, some of the columns may contain duplicate values. The DISTINCT keyword can be used to return only distinct values from the tables. SQL SELECT DISTINCT Synta...
SQL SELECT Statement 7 Aug 2011 | 06:13 am
SQL SELECT Statement The SELECT statement – extract information from the databases. Using the SELECT, you can do the following: - SELECTION: can be used to choose the lines you need from data tables. ...
SQL Syntax 7 Aug 2011 | 05:29 am
SQL Statements SQL is defined by rules of syntax, words and symbols that establish which can be used and how they can be combined, and by rules of syntax, rules that establish the actual meaning of an...
SQL Introduction 6 Aug 2011 | 10:20 pm
What is SQL? SQL stands for Structured Query Language, a language designed specifically for communication with databases. Unlike other programming languages, SQL is composed of very few words. This is...
