Join operations in SQL

When we want to make relations between two or more tables, we take in use join operations. We are going to understand these operations with example, so first, we will create a database, table, and then insert some data in it. Database Name – jai_school Query– Create two tables – admission and fee admission table … Read more Join operations in SQL

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