In this article, we will learn how to use aliases with SQL queries.
To make column names more readable, Aliases are used.
SQL aliases are used to give a temporary name to a table, or a column in a table. An alias only exists for the duration of the query.
In this article, we will learn how to use the BETWEEN operator with a SQL select query.
The BETWEEN operator is used to select values within a given range, begin and end values are also included in that. The values can be numbers, strings, or dates.
In this article, we will learn how to use the IN and NOT IN operator with a SQL select query.
The IN operator can be used to specify multiple values in a WHERE clause.
The IN operator is a shorthand, to remove the need of multiple OR conditions.
In this article, we will learn how to use the LIKE operator with wildcard characters in SQL.
To substitute one or more characters in a string a Wildcard character is used.
Wildcard characters are used with the LIKE operator in SQL. To search for a specified pattern in the column, The LIKE operator is used in a WHERE clause.
In this article, we will learn how to use the LIKE operator with a SQL select query.
To search for a specified pattern in the column, The LIKE operator is used in a WHERE clause.
Usually, there are two wildcards used in conjunction with the LIKE operator:
% (Percent): It can be used to represents zero, one, or multiple characters.
_ (Underscore ): It can be used to represents a single character.
The % (Percent) and the _ (Underscore) can also be used in combinations.
In this article, we will learn how to use the TOP Clause with a SQL select query.
The SELECT TOP clause is used to specify the number/percent of records to return.
The SELECT TOP clause is useful with thousands of records on large tables.
In this article, we will learn how to display SQL data in descending order using the ORDER BY keyword.
To sort the result-set in ascending or descending order in SQL, The ORDER BY keyword is used.
By default, the ORDER BY keyword sorts the records in ascending order. Use the DESC keyword, To sort the records in descending order.
In this article, we will learn how to display SQL data in ascending order using the ORDER BY keyword.
To sort the result-set in ascending or descending order in SQL, The ORDER BY keyword is used.
By default, the ORDER BY keyword sorts the records in ascending order.
In this article, we will learn how to use AND, OR, NOT operators with a SQL select query.
AND, OR, and NOT operators can be combined with the WHERE clause.
To filter records and extract only those records that fulfill a specified condition, The WHERE clause is used.
In this article, we will learn how to write a SQL select query with Where condition.
To select data from a database in the SQL SELECT statement is used.
To filter records and extract only those records that fulfill a specified condition, The WHERE clause is used.
We can use SELECT in two ways either select all the fields available in the table or can specify field names of the table from which you want to select data.
