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.

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.

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.

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.

In This Tutorial We Will Learn About UPDATE Command In SQL . UPDATE Command Is Used To Modify The The Table Data (Records) In SQL. UPDATE Command Used With SET Key Word. For Example If You Have A Table With Some Record And You Want To Make Some Changes In That Records, Then You Can Use UPDATE Command With SET Keyword. Read More About UPDATE COMMAND In This Tutorial.

In This Tutorial We Will Learn About UPDATE Command In SQL . UPDATE Command Is Used To Modify The The Table Data (Records) In SQL. UPDATE Command Used With SET Key Word. For Example If You Have A Table With Some Record And You Want To Make Some Changes In That Records, Then You Can Use UPDATE Command With SET Keyword. Read More About UPDATE COMMAND In This Tutorial.

In This Tutorial We Learn About Select Command. Select Command Is Used To Retrieve The Data Form SQL Database And Return A Set Of Record In Shape Of Table. Select Command Is Used With FROM Keyword Read More About Select Command In This Tutorial

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.

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.

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.