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
Date Published: 29/07/2020Published By: JaiSchool
LIMIT is used to display a certain number of rows from the table. n = Number of rows Database: jai_schoolTable: […]
0 CommentsRead More
Date Published: 29/07/2020Published By: JaiSchool
NULL :- When a table contains two or more columns and we insert data into only one column then data […]
0 CommentsRead More
Date Published: 28/07/2020Published By: JaiSchool
We use CONCAT() function in SQL to concatenate two or more column’s data. To understand CONCAT(), we are going to […]
0 CommentsRead More
Date Published: 27/07/2020Published By: JaiSchool
SQL query to change column’s data type:-
0 CommentsRead More
Date Published: 26/07/2020Published By: JaiSchool
We can copy the whole table or its specific columns we want to copy. Create table and copy another table […]
0 CommentsRead More
Date Published: 25/07/2020Published By: JaiSchool
In SQL, we use CASE to apply conditions. See practical example below- Database ~ jai_school Create a table result Insert […]
0 CommentsRead More
Date Published: 25/07/2020Published By: JaiSchool
Sql MIN() function is to get the minimum number from a column. And, MAX() function is used to display maximum […]
0 CommentsRead More
Date Published: 21/07/2020Published By: JaiSchool
in SQL, we can use operators with WHERE query so that we can display/filter data from tables according to our […]
0 CommentsRead More
Date Published: 21/07/2020Published By: JaiSchool
SQL SUM is used to do the addition of a column’s data. SQL query structure with SUM For example: Database […]
0 CommentsRead More
Date Published: 20/07/2020Published By: JaiSchool
UNION and UNION ALL both are used to display data from two or more tables. The difference between them is […]
0 CommentsRead More