Join operations in SQL

Date Published: 25/08/2020Published By: JaiSchool

When we want to make relations between two or more tables, we take in use join operations. We are going […]

0 CommentsRead More

LIKE operator and its wildcards in SQL

Date Published: 23/08/2020Published By: JaiSchool

We use LIKE operator and its wildcard with WHERE clause to search for a pattern match in a column. Wildcards […]

0 CommentsRead More

HAVING clause in SQL

Date Published: 23/08/2020Published By: JaiSchool

HAVING clause is used to filter out records based on aggregated values. In the respect of aggregation, WHERE can’t be […]

0 CommentsRead More

SQL Constraints

Date Published: 23/08/2020Published By: JaiSchool

NOT NULL PRIMARY KEY UNIQUE FOREIGN KEY CHECK DEFAULT

0 CommentsRead More

How To Rename a Column using SQL?

Date Published: 23/08/2020Published By: JaiSchool

This is a very simple process. For example, I have a table mobiles and this table contains a column brand. […]

0 CommentsRead More

WHERE query using Boolean

Date Published: 22/08/2020Published By: JaiSchool

While writing a WHERE query, when you simply give column name after WHERE keyword. It means true in boolean. Understand […]

0 CommentsRead More

Handling NULL values in SQL

Date Published: 22/08/2020Published By: JaiSchool

If a column’s field has NULL value then it means, it is blank. This field has no value. When a […]

0 CommentsRead More

SQL length() function

Date Published: 22/08/2020Published By: JaiSchool

SQL length() function:- We use this to display data from a table according to the length of the values stored […]

0 CommentsRead More

SQL COUNT() function | Get length of rows in a table

Date Published: 30/07/2020Published By: JaiSchool

A table ‘students‘ that has some rows in it (table image is given below). How many rows this table have? […]

0 CommentsRead More

SQL DISTINCT | Filter duplicate data

Date Published: 30/07/2020Published By: JaiSchool

To filter duplicate data from a table, we use a DISTINCT keyword before the column name (of which data is […]

0 CommentsRead More