Where Archives

How To Use AND, OR, NOT Operators In SQL

Yasin Panwala Nov 9, 2019 0 674

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 804

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 Where Condition With Delete Query In SQL

Yasin Panwala Nov 8, 2019 0 710

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 Use Where Condition With Update Query In SQL

Yasin Panwala Nov 8, 2019 0 813

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.

Subscribe