Operator Precedence

The basic operators used in SQL are * /   - +

Operators of the similar priority are evaluated From Left to right

Parentheses are used to force prioritized evaluation.

Example:

SELECT ENAME, SAL, 12*SAL+100

FROM EMP;

SELECT ENAME, SAL, 12*(SAL+100) FROM EMP;

 

Posted Date: 3/11/2013 12:59:22 AM | Location : United States

Ask an Expert

Related Discussions:- Operator precedence-data manipulation language, Assignment Help, Ask Question on Operator precedence-data manipulation language, Get Answer, Expert's Help, Operator precedence-data manipulation language Discussions

Write discussion on Operator precedence-data manipulation language
Your posts are moderated

Write your message here..

Related Questions

Discuss the mechanism to read data from and write to a disk, Discuss the me... Discuss the mechanism to read data from and write to a disk? Disk read/write heads are mechanisms in which read data from or write data to disk drives. The heads have gone by

Relationship between security and integrity, Relationship between Security ... Relationship between Security and Integrity: Database security usually refers to access, while database integrity refers to avoidance of accidental loss of consistency. But usually

RDBMS, what is RDBMS? how it works? good example. what is RDBMS? how it works? good example.

Log based recovery, under what condition log based recovery is feasible? under what condition log based recovery is feasible?

What is datawarehousing, What is DataWarehousing? Subject-oriented, me... What is DataWarehousing? Subject-oriented, meaning that the data in the database is organized so that all the data elements relating to the similar real-world event or object

Entity relationship diagram, The Enhanced Entity Relationship Diagram (ERD)... The Enhanced Entity Relationship Diagram (ERD) produced with a drawing or case tool. Your EERD must use a ''standard'' notation style such as Crows Foot or Chen. Please note that t

The file based system in dbms, The File Based System File based systems... The File Based System File based systems are an early attempt to computerise the manual filing system. For example, a manual file can be set up to hold all the correspondence r

Describe hashing in dbms, Describe Hashing in DBMS? Hashing: Hashing ... Describe Hashing in DBMS? Hashing: Hashing is a technique to store data within an array so which storing, searching, inserting and deleting data is fast (in theory it's O(1))

Describe specialsation and generalization, Describe Specialsation and gener... Describe Specialsation and generalization? Specialisation /generalization: This is a top down and bottom up approach to the design of database. It displays the IS_A relation

Name the metrics for selecting top algorithm, Name the metrics for selectin... Name the metrics for selecting top algorithm There are a number of metrics for selecting top algorithm: i) Computational complexity: Computational complexity refers to eff