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
Rearrange Classes and Operations Sometimes, the similar operation is defined across different classes and can easily be inherited from a familiar ancestor, but more often oper

A step-wise distributed database design methodology Following is a step-wise methodology for distributed database design. (1) Examine the nature of distribution. Find out wh

A super key is an attribute or set of attributes used to recognize the records uniquely in a relation. For instance, in the Relation PERSON defines earlier PERSON_ID is a super

Describe the candidate key functions ? Candidate Key and Alternate Key: In some instances, an entity will have more than one attribute which can serve as a primary key. Any key

Given the following relations TRAIN (NAME, START, DEST) TICKET (PNRNO., START, DEST, FARE) PASSENGER (NAME, ADDRESS, PNRNO.) Write SQL expressions for the following queries: No

Define Physical and Logical independence  Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

A B-tree of order how much children m has maximum ? m has maximum m mchildren in a B tree.

Data Scrubbing 70,000 records Project Description: We need services of a developer competent in data cleansing/Data scrubbing. Scope: - 70,000 records in CSV format.

What are the kinds of Strings?  -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt

What are two special events? The two special events are as "entry" and "exit". Any action which is marked as linked to entry event is executed whenever given state is entered v