Explain with an example boolean expression in SQL.

1.	Explain with an example boolean expression in SQL.
Answer» Boolean expressions return rows (results) when a single value is matched. Boolean expressions commonly used in a WHERE clause are made of operands operated on by SQL operators. For example, > SELECT * FROM EMPLOYEES WHERE AGE = 45; The above statement returns all those records (rows) whose age column is having the exact value of 45 from the employees table.

Answer»

Boolean expressions return rows (results) when a single value is matched. Boolean expressions commonly used in a WHERE clause are made of operands operated on by SQL operators.

For example,

> SELECT * FROM EMPLOYEES WHERE AGE = 45;
The above statement returns all those records (rows) whose age column is having the exact value of 45 from the employees table.

Discussion

No Comment Found

Related InterviewSolutions

Explain DDL commands with example.
Explain AND operator using where in SQL.
List the components of SQL architecture.
What is the dual table?
Classify numeric and character string data types in SQL.
What is commit command?
What is drop command in SQL.
Expand the term SQL.
What is update command?
Give the command to display all the details in the table.

Explain with an example boolean expression in SQL.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment