SQL

The like operator is used with the where clause for searching some specified pattern from a column. If you are unfamiliar with SQL datatype, check out my SQL Datatypes tutorial on this blog. SQL Wildcard Characters SQL wildcard characters are used for substituting one or more characters in a string. Wildcard operators, or you can … Read more

When the condition is satisfied, column values for each matched pair of rows of two tables are combined into a result row. You can also check out the SQL LEFT JOIN tutorial on this blog. SQL INNER JOIN SQL Inner join combines records from two or more tables in a database. The inner join is … Read more

SQL Subquery is used to return data, which will further be used in the main query as a condition to restrict the data also to be retrieved. It can be used with the SELECT, INSERT, UPDATE and DELETE statements and the operators like =, <, >, >=, <=, IN, BETWEEN, etc. SQL Subqueries SQL subqueries … Read more

We often use the aggregate functions with the SELECT statement’s GROUP BY and HAVING clauses. SQL aggregate functions SQL aggregates are built-in functions used for various operations on multiple rows of a particular column, resulting in a single value. An aggregate function allows you to perform the calculation on a set of values to return a … Read more

SQL Datatypes represent the nature of data stored in the database. The data type is the set of representable values. It is also known as the attribute that specifies the object’s data type. Each column, variable, and expression has the related data type in the SQL while creating the table. For example, in the last … Read more

In this section, we cover standard date functions in SQL. The different database system has different formats for date type data, and each RDBMS may employ different date functions, and there may also be differences in the syntax for each RDBMS even when the function call is the same. SQL Date Functions MySQL comes with the … Read more

Select query in SQL is one of the most powerful and heavily used commands. This is the first command anyone learns in SQL, even before CREATE, which is used to create a table in SQL. SQL SELECT SQL SELECT statement is used to fetch the data from a database table in the form of a … Read more

While updating records, you need to specify which record needs to be updated via the WHERE clause; otherwise, all the rows would be affected. We can update the single and multiple columns using the UPDATE statement per our requirement. SQL UPDATE SQL UPDATE statement is used to modify the existing records in a table. SQL … Read more

SQL is a DML, so we can add, modify or delete the rows from the table. We have already seen how to create a table, insert a row and update a row, and now we will see how to remove or delete the row from the SQL table. To remove rows or delete the table in … Read more

Sorting is just re-arranging our query results in a specified way. For example, sorting can be done on the number, strings, and date data types. SQL ORDER BY SQL Order By clause is used to sort the result in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. … Read more

SQL exists operator is used for checking the existence of a record in any subquery. The exists condition is combined with a subquery and is met if the subquery results in any row. The result of exists keyword is a Boolean value, i.e., True or False. It can select, insert, update, or delete a query. … Read more