 true

Take BTech Tuition from the Best Tutors

• Affordable fees
• 1-1 or Group class
• Flexible Timings
• Verified Tutors

Search in

# DBMS - SQL - Any/All Radhe Shyam
02/04/2021 0 0

All - Operator

SELECT empno, sal

FROM   emp

WHERE  sal > ALL (1999, 2999, 3999);

Output of Above query is same as below query

SELECT empno, sal

FROM   emp

WHERE  sal > 1999 AND sal > 2999 AND sal > 3999;

ANY Operator:

SELECT empno, sal

FROM   emp

WHERE  sal > ANY (1999, 2999, 3999);

Output of Above query is same as below query

SELECT empno, sal

FROM   emp

WHERE  sal > 1999 OR sal > 2999 OR sal > 3999;

0 Dislike
Follow 1  ## Other Lessons for You

A python program using the datetime module
Task : To write a program in Python to find out, in any given year, Friday the 13th dates i.e 13th day of a month which was a Friday. ... A program to determine the molecular weight of a hydrocarbon based on the number of Hydrogen,Carbon and Oxygen atoms.
import osimport math# A program to calculate Molecular Weight of a Hydrocarbon # These are the atomic weights(grams/mole) of Hydrogen,Carbon and OxygenatomicwtH = 1.0079atomicwtC = 12.011atomicwtO = 15.994Hatoms... A Python Program to calculate Variance and Standard Deviation
Finding the variance and the standard deviation. Variance and Standard Deviation are related measures of dispersion that tell us more about a list of numbers,like are they... A program to calculate Correlation Coefficient
Task: Calculating the Correlation-coefficient using Python We know that the correlation coefficient is calculated using the formula nΣxy- ΣxΣy / (√(nΣx^2-(Σx)^2)... Using the random module: another program.
A Python module is just a file that contains reusable code like functions. If a program is going to use functions that are stored in another module, it needs to first import that module.The random module... ### Looking for BTech Tuition ?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

X

### Looking for BTech Tuition Classes?

The best tutors for BTech Tuition Classes are on UrbanPro

• Select the best Tutor
• Book & Attend a Free Demo
• Pay and start Learning  ### Take BTech Tuition with the Best Tutors

The best Tutors for BTech Tuition Classes are on UrbanPro 