In this article, we will learn how to use the NULL Functions in SQL.
The following are the commonly used SQL NULL Functions.
In this article, we will learn how to use the Aggregate Functions in SQL.
An Aggregate Function allows us to perform a calculation on a set of values to return a single scalar value. We often use aggregate functions with the GROUP BY and HAVING clauses of the SELECT statement.
In this article, we will learn how to get the second highest salary in SQL.
In this article, we will learn how to use the String Functions in SQL.
SQL Server has many built-in String Functions.
In this article, we will learn how to create a View using SQL query.
The CREATE VIEW statement is used to create a new view in a database.
In this article, we will learn how to write a SQL insert into select query.
To copy data from one table and insert it into another table in SQL, the INSERT INTO SELECT statement is used.
Data types in source and target table should match.
Existing records in the target table are unaffected.
In this article, we will learn how to write a SQL select into query.
To copy data from one table into a new table in SQL, the SELECT INTO statement is used.
With the column-names and types as defined in the old table, the new table will be created. You can create new column names using the AS clause (Aliases).
Introduction
In this article, we will learn how to use ANY, ALL operators with a SQL select query.
The ANY and ALL operators are used with a WHERE clause or HAVING clause.
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.
