Logical operators-logical operators, Database Management System

Assignment Help:

Logical Operators

Rules of Precedence:

Order evaluated	Operator
1	All comparison operators

2	NOT
3	AND
4	OR

Example: To produce those records of salesman or president who are having salary above 15000/-

Select ename, job, sal from emp

Where job = 'SALESMAN' or job = 'PRESIDENT'

And sal>15000;

The query formulation as above is wrong for the problem statement. The correct formulation would be:

SELECT ENAME, JOB, SAL FROM EMP

WHERE (JOB = 'SALESMAN' OR JOB = 'PRESIDENT') AND SAL>15000;

Related Discussions:- Logical operators-logical operators

Sql queries, find a name whose address is erode from student table

find a name whose address is erode from student table

Explain the natural join, Explain the Natural join Natural join is a bi...

Explain the Natural join Natural join is a binary operator which is written as (R* S) in which R and S are relations. The effect of the natural join is the set of all combinati

Management information system, management information system based on funct...

management information system based on functional organisation

Data Minnning, Can i get help with weka software

Can i get help with weka software

Explain p command in the respect of qbe, Explain P command in the respect o...

Explain P command in the respect of QBE? P: It is the command in which is used to print (logically display) the value of the attribute in whose cell it is writ

Eer diagram, Design an EER schema for the following application and transla...

Design an EER schema for the following application and translate the EER schema into relational schemas (and constraints). It is possible that some requirements cannot be captured

Examine about the behavioural diagrams, Examine about the Behavioural Diagr...

Examine about the Behavioural Diagrams The main objective of behavioural diagrams is to visualize, specify, construct and document dynamic aspects of a system. The interactio

What is the candidate key for a table with columns, For problems 1-4, give ...

For problems 1-4, give all candidate keys for the tables with FDs specified. Composite candidate keys must be put in parentheses, and candidate keys must be separated with commas

Explain degree of relation, Explain degree of relation? Degree of a Re...

Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.

Express the ways provided by mysql for pattern matching, Express the ways p...

Express the ways provided by MySQL for Pattern Matching? MySQL provides two kinds of pattern matching. 1) One is based on SQL patterns 2) Regular expressions.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages