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

Explain data models namely relational network - hierarchical, Explain the t...

Explain the three data models namely relational, network and hierarchical and evaluate their relative advantages and disadvantages. Hierarchical Model: In hierarchical model, da

DBMS, give some example real life situation where DBMS are most suitable

give some example real life situation where DBMS are most suitable

List the data structures implemented by the storage manager, List the data ...

List the data structures implemented by the storage manager. The storage manager executes the following data structure a) Data files b) Data dictionary c) indices

Data base design, how to design a bakery business in data base

how to design a bakery business in data base

Explain projection operation distribute over union operation, Illustrate th...

Illustrate the statement 'Projection operation distributes over the union operation'. Give an example. Ans: Π L (E 1 ∪ E 2 ) = (Π L (E 1 )) ∪ (Π L (E 2 )) This says th

Describe in brief about object oriented design, Describe about Object orien...

Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

Explain the concept of data mining, Question 1 Explain the concept of Fore...

Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)

Mobile database, write short note on mobile database

write short note on mobile database

Define single valued and multivalued attributes, Define single valued and m...

Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. M

Data analyzing and desing, Critically explained the benefits and limit...

Critically explained the benefits and limitations of different database technologies with proper examples

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages