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
Explain what is RDBMS ? RDBMS - RDBMS is a database management system (DBMS) which stores data within the form of relations. Relational databases are powerful since they need f

Can we delete data element, which is being used by table fields. No we cant delete data element.


Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

What is key ? Key - A single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances (rows) of the set (table) is

Importance Of File Organisation In Database To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. F

Example: RELATIONAL SCHEMA for PERSON: PERSON (PERSON_ID: integer, NAME: string, AGE: integer, ADDRESS: String) RELATION INSTANCE In this instance, m = 3 and n = 4

Conflicting Operations in Schedule: The three simple ways of interleaved instruction implement of transactions T1 and T2. Please note that in the following tables the first col

Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))

What is a view?  Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary.  Ans:  View is a virtual table that does not consist