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