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;

Posted Date: 3/11/2013 1:06:37 AM | Location : United States

Ask an Expert

Related Discussions:- Logical operators-logical operators, Assignment Help, Ask Question on Logical operators-logical operators, Get Answer, Expert's Help, Logical operators-logical operators Discussions

Write discussion on Logical operators-logical operators
Your posts are moderated

Write your message here..

Related Questions

System Analysis and design, Using the questions found at the end of Chapter... Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.

Define dbms, Define DBMS? DBMS: database management system (DBMS) is co... Define DBMS? DBMS: database management system (DBMS) is computer software designed for the reason of supervision databases based on a variety of data models.

Database systems have many opposite efforts, Database systems have many op... Database systems have many opposite efforts ?

Datawarehouse, 1) Define a job scheduling strategy that will meet business ... 1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

List the types of authorization, List the types of authorization. A) R... List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization

What disadvantage of odbc does ole db overcome, What disadvantage of ODBC d... What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC

What is use of generating such tables, What is use of generating such table... What is use of generating such tables? How can you create temporary tables? When you require a table only for a short time after that you want it to disappear automatically you

What is the concurrency identification, Concurrency Identification Whi... Concurrency Identification While designing analysis, model we map real world model into our analytical model. Real life objects are simultaneous in nature, but all the design

Which data type can store unstructured data, Which data type can store unst... Which data type can store unstructured data? Raw data type can store unstructured data.

Recovery techniques, Recovery Techniques: After Reading the types of failur... Recovery Techniques: After Reading the types of failures and database errors, let us talk about how to recover from the failures. Recovery can be complete using/restoring the previ