Discussion | SoloLearn: Learn to code for FREE!

+1

Discussion

Do you anyone think that SoloLearn forgot to include the Widely used keywords "ALL and ANY" in SQL? It is very important used keywords to filter results in a database sometimes.. If you think yes, just be with me or support me to make Sololearn think to include these two too in SQL asap..If I am wrong, give me the reason why it is not necessary..Thanks a lot for any valuable suggestions in advance..

sql

4/1/2019 2:06:08 PM

Pawan Kumar

7 Answers

New Answer

+3

I didn't know these ALL and ANY, are they part of SQL standard? can you give me an example how, when and where they are used? I'm just learning this language BTW.

+3

Thank you sneeze and Pawan Kumar Always good to know and learn something new 👍

+1

Yes ANY and ALL are part of the sql standard. They are used in the where clause https://www.w3schools.com/sql/sql_any_all.asp SELECT column_name(s) FROM table_name WHERE column_name operator ANY (SELECT column_name FROM table_name WHERE condition); SELECT column_name(s) FROM table_name WHERE column_name operator ALL (SELECT column_name FROM table_name WHERE condition);

+1

Yes, All and any are parts of SQL Standard.. e.g.:- SELECT P1.address FROM Cinema P1 WHERE P1.capacity>=ALL(select P2.capacity FROM Cinema P2) It always finds the addresses of theaters with maximum capacity. I hope, it will give you a brief idea about these. If you need any other assistance, kindly msg me, lpang..

+1

Welcome, lpang!

0

using an asterisk ( * ) is equivalent to All. most of time it easy to type *. the sololearn course is just an introduction with some basics. if you need to go pro a lot of things are required, efficiency and performance being one....

0

But, it is also not so much difficult thing to add these two..It should also be mentioned as IN, not IN etc..Don't you think so?