Logical operators-logical operators, Database Management System

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







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
Related Questions
Using your cache simulator and using smalltex.din as your memory trace determine the total miss rate, compulsory miss rate, capacity miss rate, and conflict miss rate for the follo

Niles Video Inc. wants to create a website for online sales of movies (DVD and videotapes). People will be allowed to register as customers on the website and to update their store

In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

For each 1: n relationship type R involving two entities E1 and E2, we recognize the entity type (say E1) at the n-side of the relationship type R and contain primary key of the en

PART MARKING:  We will only mark TWO of the four questions below but you must submit answers to all four. We will choose the questions we mark randomly and we will supply you with

we need example of 2phase locking

What functions does a data dictionary perform? In a (DBMS)data management system, the principal functions performed by the data dictionary are Management of data defini

Limitations of File Based System The file-based system has some limitations. The limitations are listed as follows: Isolation and separation of data: When the data is

List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements  c) Finding the loops  d) Finding error ro

A database to track your progress in your college program will track your progress towards graduation! A database that has information containing the classes that you have taken, c