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

In This Tutorial We Will Learn About HAVING Clause In SQL . When We Use Any Aggregate Functions In Our SQL Statement Then We Can't Use The WHERE Clause With These Type Of Statement. For Example If We Use SUM Function In SELECT Statement Using GROUP BY Clause Then We Can Not Use The Where Clause. Read More About HAVING Clause In This Tutorial.

IN Operator In SQL Return The Entire Record Exact Match With Given Values. For Example If We Want To Match More Then One Value In Our Condition For Example From Table Below If We Want To Select Those Record Who's City Is Karachi Or Lahore. Read More About IN Operator 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 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.

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.

WHERE clause select the record conditionally from SQl database. WHERE keyword use with different statement in SQL for example WHERE with Select Statement, Delete from statement, Update statement etc. In This tutorial we explain WHERE clause with SELECT Statement. In SELECT Statement we give a condition with WHERE clause. Those record which satisfied the given were display.

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