select Archives

How To Use LIKE Operator With Wildcard Characters In SQL

Yasin Panwala Nov 11, 2019 0 974

In this article, we will learn how to use the LIKE operator with wildcard characters in SQL.

To substitute one or more characters in a string a Wildcard character is used.

Wildcard characters are used with the LIKE operator in SQL. To search for a specified pattern in the column, The LIKE operator is used in a WHERE clause.

How To Use LIKE Operator In SQL

Yasin Panwala Nov 9, 2019 0 772

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

To search for a specified pattern in the column, The LIKE operator is used in a WHERE clause.

Usually, there are two wildcards used in conjunction with the LIKE operator:

% (Percent): It can be used to represents zero, one, or multiple characters.
_ (Underscore ): It can be used to represents a single character.

The % (Percent) and the _ (Underscore) can also be used in combinations.

How To Use TOP Clause In SQL

Yasin Panwala Nov 9, 2019 0 724

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

The SELECT TOP clause is used to specify the number/percent of records to return.

The SELECT TOP clause is useful with thousands of records on large tables.

How To Use AND, OR, NOT Operators In SQL

Yasin Panwala Nov 9, 2019 0 672

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 803

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 771

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 784

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.

CRUD Operation In ASP.NET

Yasin Panwala Oct 31, 2019 0 3.9K

In this article, we will learn about how we can perform crud operations using ADO.NET in ASP.NET.

Subscribe