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
We use LIKE operator and its wildcard with WHERE clause to search for a pattern match in a column. Wildcards to use with LIKE Wildcards Definition Example “s%” ‘S’ at First Position See “%s” ‘S’ at Second Position See “%s%” ‘S’ at Any Position See “_s%” ‘S’ at Second Position See “s%g” ‘S’ at First … Read more LIKE operator and its wildcards in SQL
HAVING clause is used to filter out records based on aggregated values. In the respect of aggregation, WHERE can’t be used. It does not work. Therefore, while applying condition where we are calculating fields data, we will use HAVING. See below example-
NOT NULL PRIMARY KEY UNIQUE FOREIGN KEY CHECK DEFAULT
This is a very simple process. For example, I have a table mobiles and this table contains a column brand. Now, I want to change the name of the column from brand to brand_name. Then, Run following command to rename the column- Do not try to change its data type like INT to VARCHAR or … Read more How To Rename a Column using SQL?
While writing a WHERE query, when you simply give column name after WHERE keyword. It means true in boolean. Understand it with example. Make a database by running query– Create a table in the database– Insert data in the table– Table Image: When you run above query, you see only NULL values are filtered if … Read more WHERE query using Boolean
If a column’s field has NULL value then it means, it is blank. This field has no value. When a column’s value is NULL then it can’t be determined by an eqal to (=) operator. The way of identifying NULL values is, you need to use IS NULL or IS NOT NULL statement. NOT NULL … Read more Handling NULL values in SQL