ALIAS In SQL

In This Tutorial We Will Learn About ALIAS In SQL . In SQL ALIAS Are Temporary Name Of The Table Or Column. Some Time When We Get The Output For Example When We Calculate The Value Like Using SUM Function Or Use GROUP BY Claus Then Our Column Heading Are Not Simple And Understandable Then We Use ALIAS. Read More About ALIAS In This Tutorial.


LIKE Operator in SQL

In This Tutorial We Will Learn About LIKE Operator In SQL . LIKE operator is pattern matching In SQL. LIKE means Not Exactly just match some pattern for example when we use IN or BETWEEN or in Equal To (=) relational operator, then the Complete value compare if its match the whole value which is given in Condition then Its return other wise not. Read More About LIKE Operator In This Tutorial.


Logical Operator in SQL SELECT Statement

 In SELECT statement we can also use logical operator with WHERE clause. There are Three logical operator AND , OR and NOT. These logical operator combine the multiple condition. These operator also called conjunctive operators which provide a facility of multiple comparison.


INSERT INTO Command In SQL

In This Tutorial We Will Learn About INSERT INTO Command In SQL . In SQL INSERT INTO Command Add The New Record (Row) In A Table. You Can Insert The Data With The Help Of INSERT INTO Command In Two Ways. Read More About INSERT INTO Command In This Tutorial.


Use of Wildcards in SQL

In This Tutorial We Will Learn About wildcards and Use of wildcards in SQL. In SQl wildcards are used with LIKE operator which are substitute for any other character or characters . In SQL we can use two wildcards with LIKE operator which are percentage symbol ( %, ) and underscore symbol ( _ ). . Read More About wildcards In This Tutorial.




INSERT INTO Command In SQL

In This Tutorial We Will Learn About INSERT INTO Command In SQL . In SQL INSERT INTO Command Add The New Record (Row) In A Table. You Can Insert The Data With The Help Of INSERT INTO Command In Two Ways. Read More About INSERT INTO Command In This Tutorial.


AS Keyword In SQL

In This Tutorial We Will Learn About AS Keyword In SQL . In SQL When We Assign The ALIAS To Any Column Or Table Then We Use AS Keyword. Although We Assign The ALIAS With Out AS Keyword But Using As Keyword Is A Explicit Way. Read More About AS Keyword In This Tutorial.


AVG Function in SQL

In This Tutorial We Will Learn About AVG Functionin SQL . AVG Function In SQL Is Use To Calculate The Average Of Numeric Values. The General Syntax Of AVG Function Is: Read More About AVG Function In This Tutorial.


Distinct clause with Select Command

In This Tutorial We Learn About Select Command Distinct Clause. Distinct Clause With Select Command Display The Unique Values Of The Specified Column From SQL Database Table Read More About Select Command In This Tutorial.


BETWEEN Operator in SQL

In This Tutorial We Will Learn About BETWEEN Operator In SQL . When We Use Between Operator Then It Compare All The Records Which Match With Our Given Range After BETWEEN Operator. Read More About BETWEEN Operator In This Tutorial.