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
Date Published: 23/08/2020Published By: JaiSchool
We use the LIKE operator and its wildcard with the WHERE clause to search for a pattern match in a […]
0 CommentsRead More
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
Date Published: 23/08/2020Published By: JaiSchool
NOT NULL PRIMARY KEY UNIQUE FOREIGN KEY CHECK DEFAULT
0 CommentsRead More
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
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
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
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
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
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