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 are the uses of the information in the Data dictionary? The following information is directly taken from the Data dictionary: Information on fields displayed with

Explain the Query Processing  Data Query Processing permits a user to report or analyze structured and unstructured data pulled from multiple data sources.

This report identifies and outlines my CIS 499 project named Traffic Data Management  Systems (TDMS) .   My goal is to design a replica of all traffic issues to be implemented i

Ask questiwhat is row indicator in database on #Minimum 100 words accepted#

Assigning Responsibility for Operation Many operations might have obvious target objects, but some of these operations could be used at numerous places in an algorithm, by one

What is the most significant feature that does not directly map into programming language structures? Why? Association, since there are complex types of association, like as qu


Express types of information available in MySQL? Information as regards the result of queries:  This includes number of records affected by any SELECT or UPDATE or DELETE st

What do you mean by DBMS? What is its need and what are its goals. Explain?        OR   Explain Data Base Management System? Sol.  Database management system is a