SQL LIMIT | Display certain rows from a table

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

SQL NULL, AUTO_INCREMENT & PRIMARY KEY()

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

CONCAT() in SQL

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

How To Modify A Column in SQL

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

SQL query to change column’s data type:-

0 CommentsRead More

Copy Table or a Particular Column’s data in another table SQL

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

CASE in SQL

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

MIN() and MAX() functions in SQL

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

Use of SQL Operators with WHERE in SQL

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

SQL SUM Query

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

UNION & UNION ALL in SQL

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