Select Command In SQL Server

1. Select
2. Select Distinct
3. Select Where with Arithmetic Operator
4. Select Where with Comparison Operator
5. Select Where with Logical Operator

SQL: Select command with Where clause with different options.

SQL Select command

As command itself define its functionalities Select command select the rows and columns as per given in command.

Table : tblFriends structure with Data Records
Normal Select Command

Syntax1

Select * From <TableName>

Example1

Select * From tblFriends

Above command will return all rows and columns from tblFriends.



Note: This is not a good practice, Always specify your columns in select command while you use in programming.

Syntax 2

Select <ColumnName>, <ColumnName> …. From <TableName>

Example 2

Select Name, Place, Phone From tblFriends

Above command will return all rows but selected columns are: Name, Place, Phone.



How to display distinct, Non-duplicate records from table

Syntax:

Select Distinct <ColumnName>, <ColumnName> …. From <TableName>

Example:

Select Distinct Place From tblFriends

Above command will not display duplicate records. It will display unique place name from tblFriends table.



Total 14 records but distinct PLACE value come around 11 records.

Duplicate Places

Lodiyo 2 Time
Phalodi 2 Time
Pokaran 2 Time

You can check repeated PLACE with this command also.

Select Count(*) as Total, Place from tblFriends group by Place,



Select Where with Arithmetic Operator

The following are Arithmetic operator,

1. + = Addition
2. – = Subtraction / Minus
3. * = Multiplication
4. / = Divide

+ = Addition

Now, I am going to add two different fields value into one in query.

PackingCharges + TransportCharges = TotalCharges

Query


– = Subtraction/Minus


* = Multiplication


/ = Divide

Select 55/5 as Result.



Select Where with Comparison Operator

The following are Arithmetic operators,