answersLogoWhite

0


Best Answer

Yes. For example, using a database containing a table clients:

SELECT clients.Name

FROM clients

WHERE clients.city='New York'

would show ONLY the clients from New York

User Avatar

Wiki User

12y ago
This answer is:
User Avatar
More answers
User Avatar

AnswerBot

1w ago

The WHERE statement is used in SQL to specify a condition that must be met for a record to be included in the result set. It is typically used in conjunction with the SELECT, UPDATE, DELETE, or INSERT statements to filter rows based on specific criteria.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: WHERE statement is used to define a filter expression?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the method used to implement an if else statement in C?

The else statement is an optional part of an if statement that is executed if the primary if condition is false.if (condition) true_statementelse false_statement


What is while statement and how is it used?

You use a while statement to introduce a conditional loop. Unlike a for loop which is typically used for counted loops, a while loop is used whenever a statement must iterate while an expression evaluates true. The expression is evaluated at the start of each iteration.


What is an expression in Oracle Database?

select statement in oracle which is used to calculate average,min,max etc is an expression


How 'if' statement is different from a 'switch' statement in C language?

The if statement is used to select among two alternatives. It uses a boolean expression todecide which alternative should be executed. The switch statement is used to select among multiple alternatives. It uses an int expression to determine which alternativeshould be executed.


A statement of the procedures used to define research variables is known as a?

Control Condition


How would you declare a constant of 5 called MYCONST?

A constant of 5 called MYCONST would be declared as #define MYCONST 5. This is because the statement used is a define statement.


How to write an if then statement?

It depends on the language however most use the following syntax: if (expression) then statement else statement endif Note that the "then" and "endif" keywords are not used in all languages since they are implied by the statement's structure and are normally only found in verbose languages such as BASIC. In C and C++, for instance, we have the following form: if (expression) { statement; } else { statement; } The expression must be a boolean expression; one that evaluates true or false. If the expression evaluates to a number, the expression evaluates true when the number is non-zero, otherwise it is false. When the expression is true, the first statement is executed otherwise the second statement is executed. Often we do not wish to execute anything when an expression is false, only when it is true, so the else clause is optional. if (expression) statement; In languages that use braces {} to denote structure, they are usually optional for simple statements but mandatory for compound statements. A compound statement is a group of statements that are treated as being one statement. Either statement may itself be an if statement (a nested if): if (expression) { if (expression) { statement; } else { statement; } } else { statement; } Spreading if statements over multiple lines and using whitespace indentation helps to highlight the logic and structure of the statement. It is not possible to show whitespace indentation here, but here's the same example using periods instead of whitespace: if (expression) { ...if (expression) { ......statement; ...} else { ......statement; ...} } else { ...statement; } Note the use of blank lines to separate the inner (nested) if from the outer if.


What does an IF Statement do?

An if statement is a control statement. It is used to control whether a statement executes or not, depending on whether a control expression evaluates true or false.if (expression) {statement;}In the above example, the expression is evaluated. If true, the statement executes, otherwise it does not.if (expression) {statement1;} else {statement2;}In the above example, the expression is evaluated. If true, statement1 executes otherwise statement2 executes.Note that if statements may be chained together using else if statements. The final else clause (if present) then becomes the default case. Also, any statement within an if statement may itself be an if statement, known as a nested if. If statements may be chained or nested to any depth.


When no semicolon is used after printf statement what will be the output?

A semi-colon denotes the end of a statement. If you omit the semi-colon, the statement will extend into the next expression and this will result in a compiler error because a semi-colon will have been expected at the end of the first expression.


Why the semicoloumn is used in c program?

Why semicolon? Tradition.What does it do? Terminates a single statement, eg:i+= 3; /* expression is a single statement */{ i= 3; --j; } /* no semicolon after the compound statement */


How If and else run at a time?

The standard syntax is:if( conditional_expression )statement;[[else if( conditional_expression )statement;[else if...]]else statement;][] denotes optional components. Each statement may be a single statement, or may be multiple statements surrounded by braces {}.The if( conditional expression ) statement; is the only required component. In plain English, this reads: if the conditional expression is true, then execute the following statement, otherwise skip to the line following the statement.If the next line is an else statement, then the line reads: if the conditional expression is true, then execute the statement and skip over the else statement. But if the conditional expression is false, then skip over the statement and execute the else statement instead.if( conditional_expression )statement; // execute when conditional expression is trueelsestatement; // execute when conditional expression is falseThe statement following the else can be another ifstatement (a nested if):if( conditional_expression_1 )statement; // execute when conditional_expression_1 is true.else if( conditional_expression_2)statement; // execute when conditional_expression_1 is false and _2 is true.elsestatement; // execute when both _1 and _2 are both false.Note that if an else statement is used without a following if statement, it must appear after all other else if statements.


What is the difference between If-else and Switch-case in Java?

The if statement is used to select among two alternatives. It uses a boolean expression todecide which alternative should be executed. The switch statement is used to select among multiple alternatives. It uses an int expression to determine which alternativeshould be executed.