Database Archives

How To Use Aggregate Functions In SQL

Yasin Panwala Dec 10, 2019 1 746

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.

How To Get Second Highest Salary Using Query In SQL

Yasin Panwala Dec 10, 2019 0 918

In this article, we will learn how to get the second highest salary in SQL.

How To Use String Functions In SQL

Yasin Panwala Dec 10, 2019 20 1.2K

In this article, we will learn how to use the String Functions in SQL.

SQL Server has many built-in String Functions.

Views In SQL

Yasin Panwala Dec 6, 2019 0 832

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.

How To Create Auto Increment Field Using Query In SQL

Yasin Panwala Dec 6, 2019 0 769

In this article, we will learn how to create an auto-increment field/column using a query in SQL.

The IDENTITY keyword is used to perform an auto-increment feature in MS SQL Server.

How To Create Index Using Query In SQL

Yasin Panwala Dec 6, 2019 1 844

In this article, we will learn how to create and delete Indexes in SQL.

To create indexes in tables, the CREATE INDEX statement is used.

How To Add Column With Default Value In SQL

Yasin Panwala Dec 5, 2019 0 1.3K

In this article, we will learn how to add a column with default value using the DEFAULT constraint in SQL.

To provide a default value for a column, the DEFAULT constraint is used.

How To Use CHECK Constraint In SQL

Yasin Panwala Dec 5, 2019 0 774

In this article, we will learn how to use the CHECK constraint in SQL.

To limit the value range that can be placed in a column, the CHECK constraint is used.

How To Use FOREIGN KEY Constraint In SQL

Yasin Panwala Dec 4, 2019 0 772

In this article, we will learn how to use the Foreign Key constraint in SQL.

A FOREIGN KEY is a key, used to link tables together.

How To Use PRIMARY KEY Constraint In SQL

Yasin Panwala Dec 4, 2019 2 721

In this article, we will learn how to use the Primary Key constraint in SQL.

The PRIMARY KEY constraint is used to identify each record uniquely in a table.

Subscribe