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

What is the use of raid, What is the use of RAID? A variety of disk-org... What is the use of RAID? A variety of disk-organization methods, collectively called redundant arrays of independent disks are used to better the performance and reliability.

What are composite attributes, What are composite attributes? Composite... What are composite attributes? Composite attributes can be separated in to sub parts.

Determine the minimal set of functional dependencies, Determine the minimal... Determine the minimal set of functional dependencies for the following data. This table is part of the OHSU database of extracurricular activities and tracks the DMICE band's co

In an e-r diagram an entity set is represent by, In an E-R diagram an entit... In an E-R diagram an entity set is represent by? In an E-R digram entity set is represted by rectangle.

Consider relational schema and construct algebra query, Consider the follow... Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru

What is called bit-level striping, Normal 0 false false fal... Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Explain thomas write rule, Explain Thomas' Write rule.  Show how it is diff... Explain Thomas' Write rule.  Show how it is different from timestamp ordering protol Ans: In timestamp-based concurrency control the thomas Write rule is a rule. Given a Timest

What is the error handling, What is the error handling Traditionally, b... What is the error handling Traditionally, bits have been sent over line lacking any error correcting scheme in physical layer. The presence of the CPU in each modem makes it po

Hashing technique, note on hashing technique note on hashing technique

Example of transaction? , Example :; transfers transfer_amount from x's acc... Example :; transfers transfer_amount from x's account to y's account ; Supposes x&y both accounts exist TRANSACTION (x, y, transfer_amount) Start transaction IF X AND Y