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
Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra

Define Fifth Normal form is concerned with Ans : Fifth Normal form is concerned with Join dependency.

I want Database Of United Kingdom with Criteria of:\r\n\r\n1). Name, Number, City, State, Postal Code, Address, Email id, DOB.\r\n\r\n2). Unsecure Debts only adds Credit Card Payme

1. Staff (staffID --> availabilityID) 2. Services (servicesID --> itemBasedID --> timedBasedID) 3. TimedBased (timedbasedID--> priceid) 4. Clients (clientId, serviceId-->


Define Shared locks? Ans: Shared lock: Throughout concurrent execution of transactions, earlier than a transaction can access a data item, it has to obtain a lock on it. Now he

What are metrics for choosing the best algorithm? Matrices for choosing the best algorithms are as below: Computational complexity Ease of understand ability and im

What is Foreign Key Foreign Key: Sometimes we may have to work with an attribute that does not have a primary key of its own. To recognize its rows, we have to use the primar

Express the following queries in SQL: (a) Write the SQL code that will create ALL the four tables given in the appendix. Your answer should not contain the primary key and