Operator precedence-data manipulation language, Database Management System

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







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
Related Questions
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? Composite attributes can be separated in to sub parts.

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 digram entity set is represted by rectangle.

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

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

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 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


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