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

A table ‘students‘ that has some rows in it (table image is given below). How many rows this table have? I want to know that. So I will use SQL COUNT() function. For this, SQL provides a COUNT() function. With the help of that, we can get the total number of rows. SQL Count() function … Read more SQL COUNT() function | Get length of rows in a table

SQL NULL, AUTO_INCREMENT & PRIMARY KEY()

NULL :- When a table contains two or more columns and we insert data into only one column then data in the second column will be automatically inserted as a NULL value. NOT NULL & AUTO_INCREMENT:- When we want to make column auto-increment then it needs to be disabled its ‘NULL‘ feature. Write NOT NULL … Read more SQL NULL, AUTO_INCREMENT & PRIMARY KEY()

CONCAT() in SQL

We use CONCAT() function in SQL to concatenate two or more column’s data. To understand CONCAT(), we are going to create a database ‘jai_school‘. The database contains the table, so make a table: users Insert some data Use CONCAT() function Other Articles SQL CASESQL MIN() and MAX() functionsSQL operators

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

We can copy the whole table or its specific columns we want to copy. Create table and copy another table data Or But column count in both tables should match if you use all column selector ( * ). In the above example, the admission table contains five columns & the users table also contains … Read more Copy Table or a Particular Column’s data in another table SQL

MIN() and MAX() functions in SQL

Sql MIN() function is to get the minimum number from a column. And, MAX() function is used to display maximum number from a table’s column. Examples are given below- Database Name– jai_school Create a table– result Insert data in result table Table Image- SQL MIN() function query result- Display MIN(marks) in another column– query result- … Read more MIN() and MAX() functions in SQL

Use of SQL Operators with WHERE in SQL

in SQL, we can use operators with WHERE query so that we can display/filter data from tables according to our thinking. There are so many operators to use with WHERE (conditional clause) in SQL which are given below. Operators for “where” query = (Equal to operator in SQL but in JS assignment operator) > (Greater … Read more Use of SQL Operators with WHERE in SQL