In This Tutorial We Will Learn About DELETE Command In SQL . DELETE Command Is Used To Remove The Record Form Specified Table. You Can Delete All Record At A Time And Also Remove A Specific Record With The Help Of WHERE Clause. The FROM Keyword Is Used With Delete Command. Read More About DELETE COMMAND 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 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 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 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 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.

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.

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