SQL Archives

How To Display SQL Data In Descending Order

Yasin Panwala Nov 9, 2019 0 715

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.

How To Display SQL Data In Ascending Order

Yasin Panwala Nov 9, 2019 0 767

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.

How To Use AND, OR, NOT Operators In SQL

Yasin Panwala Nov 9, 2019 0 666

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.

How To Use Where Condition With Select Query In SQL

Yasin Panwala Nov 9, 2019 0 796

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.

How To Use Distinct Keyword In SQL

Yasin Panwala Nov 9, 2019 0 765

In this article, we will learn how to use the DISTINCT keyword with a SQL select query.

Inside a table, a column may contain many duplicate values; To select only different (distinct) values from a database in SQL SELECT DISTINCT statement is used.

How To Write Select Query In SQL

Yasin Panwala Nov 9, 2019 0 777

In this article, we will learn how to write a SQL select query.

To select data from a database in the SQL Select statement is used. The data returned is stored in the form of a result table, called the result-set.

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.

How To Write Delete Query In SQL

Yasin Panwala Nov 8, 2019 0 794

In this article, we will learn how to write a SQL delete query.

To delete the existing data in the SQL Delete statement is used.

How To Use Where Condition With Delete Query In SQL

Yasin Panwala Nov 8, 2019 0 703

In this article, we will learn how to write a SQL delete query with Where condition.

To delete the existing data in the SQL DELETE statement is used.

To filter records and extract only those records that fulfill a specified condition, The WHERE clause is used.

How To Write Update Query In SQL

Yasin Panwala Nov 8, 2019 0 701

In this article, we will learn how to write a SQL update query.

To modify the existing data in the SQL UPDATE statement is used.

How To Use Where Condition With Update Query In SQL

Yasin Panwala Nov 8, 2019 0 809

In this article, we will learn how to write a SQL update query with Where condition.

To modify the existing data in the SQL UPDATE statement is used.

To filter records and extract only those records that fulfill a specified condition, The WHERE clause is used.

How To Display SQL Data In Descending Order

How To Display SQL Data In Ascending Order

How To Use AND, OR, NOT Operators In SQL

How To Use Where Condition With Select Query In SQL

How To Use Distinct Keyword In SQL

How To Write Select Query In SQL

How To Write Delete Query In SQL

How To Use Where Condition With Delete Query In SQL

How To Write Update Query In SQL

How To Use Where Condition With Update Query In SQL

Post Filter

Related Articles

Subscribe