true

Find the best tutors and institutes for BTech Tuition

Find Best BTech Tuition

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

DBMS - SQL - Any/All

Radhe Shyam
02 Apr 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

Please Enter a comment

Submit

Other Lessons for You

Write your first Python program in 10 minutes
1. Download python from python official site search "python download" in google 2. Install in your machine 3. verify using : "python --version" command 4. Write first program using notepad create...

Debrati Sadhu | 04/08/2020

1 0
0

Data Integrity in SQL Server
It is often told, data without integrity is just numbers. There are different situations like1. When a user enters data which is not in proper range or invalid2. A wrong DML operation is attempted by...

Pritam Chatterjee | 14/07/2020

0 0
0


Estimation of Water and Wastewater Flow
Before designing the proper waterworks project, it is essential to determine the quantity of water that is required daily. This involves the determination of the population and the rate of demand. The...

Sandip Nandi | 28/05/2020

0 0
0

Overloading in JAVA
When a class contains more than one method with the same method name but different argument types, then it is called Overloading. Methods are said to be Overloaded methods. Also, know as Compile time...

Swati S. | 19/05/2020

0 0
0
X

Looking for BTech Tuition Classes?

Find best tutors for BTech Tuition Classes by posting a requirement.

  • Post a learning requirement
  • Get customized responses
  • Compare and select the best

Looking for BTech Tuition Classes?

Find best BTech Tuition Classes in your locality on UrbanPro

Post your learning requirement

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more