Database

How To Use Aggregate Functions In SQL

In this article, we will learn how to use the Aggregate Functions in SQL. An Aggregate Function allows us to…

5 years ago

How To Get Second Highest Salary Using Query In SQL

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

5 years ago

How To Use String Functions In SQL

In this article, we will learn how to use the String Functions in SQL. SQL Server has many built-in String…

5 years ago

Views In SQL

In this article, we will learn how to create a View using SQL query. The CREATE VIEW statement is used…

5 years ago

How To Create Auto Increment Field Using Query In SQL

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

5 years ago

How To Create Index Using Query In SQL

In this article, we will learn how to create and delete Indexes in SQL. To create indexes in tables, the…

5 years ago

How To Add Column With Default Value In SQL

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

5 years ago

How To Use CHECK Constraint In SQL

In this article, we will learn how to use the CHECK constraint in SQL. To limit the value range that…

5 years ago

How To Use FOREIGN KEY Constraint In SQL

In this article, we will learn how to use the Foreign Key constraint in SQL. A FOREIGN KEY is a…

5 years ago

How To Use PRIMARY KEY Constraint In SQL

In this article, we will learn how to use the Primary Key constraint in SQL. The PRIMARY KEY constraint is…

5 years ago