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

Create a database for their customers, The ABC Bank authority now wants to ... The ABC Bank authority now wants to create a database for their customers. So you are requested to modify your program of Assignment A3 as follows. The main program first displa

Domains, A domain is a set of permissible values that can be given to an at... A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside

What is the use of integrity constraints, What is the use of integrity cons... What is the use of integrity constraints? Integrity constraints make sure that changes made to the database by authorized users do not result in a loss of data consistency. The

What is business intelligence, Question A What is operational intelligence... Question A What is operational intelligence? Question B What is Business Intelligence? Explain the components of BI architecture Question C Differentiate between databas

Fire dementpart, The State of NewYork certifies firefighters throughout sta... The State of NewYork certifies firefighters throughout state and keep track all of them, as well as of the state’s fire departments. Each fire department has unique department numb

Ddl compiler-database management system, DDL Compiler The DDL compile... DDL Compiler The DDL compiler changes the data definition statements (such as CREATE TABLE .... in SQL) into a set of tables having metadata tables. These tables have infor

Name the three major database in oracle, Name the three major set of files ... Name the three major set of files on disk that compose a database in Oracle. There are three main sets of files on disk that compose a database. All the files are binary. These

gaps in sequence values can happen when-sequences, Gaps in sequence values... Gaps in sequence values can happen when: -     A rollback happens that is when a statement changes are not accepted. -     When the system crashes -     When a sequence i

aggregate functions-data manipulation language, Aggregate functions ... Aggregate functions Some of these functions are min, count, max, and avg. These functions help in getting consolidated information from a set of tuples. Example:

Indexed (indexed sequential) file organisation, Indexed (Indexed Sequential... Indexed (Indexed Sequential) File Organisation It organises the file like a big dictionary, i.e., records are kept in order of the key but an index is stored which also allows