Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

How to use Left Join

Left Join: Left Join is used to join two tables and it return all rows from table 1 and matching rows from table 2. The result is NULL for unmatched rows for table 2. Left Join keyword is used to apply Left Join on two tables. Syntax for Le...

Truncating a table

TRUNCATE TABLE Statement: TRUNCATE Statement is used to remove all records from a table. It is a Data Definition Language (DDL) Statement as it deletes all records and only structure remains. It is similar to delete statement but without where...

Null Values

Null Values: Null values denotes missing data in a table or a database. If a column does not have any NOT NULL constraint then for that column there can be NULL values. By default a column can have NULL values. We cannot use comparison oper...

Sub Queries

Sub Queries: Sub Queries are those query which comes within another query and are written after the WHERE clause.They are also known as Inner query or nested query. It is used to return records that are used in the main query as a conditio...

DELETE Query

DELETE Statement: It is used to delete existing records from a table. It can delete all records from a table if where condition is not given and if where condition is given than it will delete selected records which will meet the condition. ...

Group By Statement

Group By : It is used to group the result-set by one or more column. It is used in conjunction with aggregate functions provided by Structured Query Language . If order by is used then Group By must come before Order By clause. Syntax1: ...
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: