GATE 2017 CS/IT DBMS | Consider SQL query: SELECT ta.player FROM top_scorer AS ta WHERE ta.goals ALL

Опубликовано: 03 Март 2026
на канале: Jatin Gupta
644
22

GATE 2017 CS/IT DBMS(SQL) | Consider the following database table named top_scorer | Consider the SQL query: SELECT ta.player FROM top_scorer AS ta WHERE ta.goals ALL (SELECT tb.goals FROM top_scorer AS tb WHERE tb. country = 'Spain') AND ta.goals ANY (SELECT tc.goals FROM top_scorer AS tc WHERE tc.country='Germany')
The number of tuples returned by the above SQL query is ______

All - https://dev.mysql.com/doc/refman/8.0/...
For any queries feel free to comment or direct message on Instagram
Instagram -   / jatingupta5jan  
Playlist link -
C Programming -    • C PROGRAMMING |GATE CS/IT  PYQ | PREVIOUS ...  
Time Complexity -    • GATE CS/IT PYQ TIME COMPLEXITY | ALGORITHM...  
Data structure -    • GATE CS/IT (PYQ) | DATA STRUCTURES  | NET ...  
Algorithms -    • GATE CS/IT (PYQ) ALGORITHMS | TIME COMPLEX...  
Binary tree -    • GATE CS/IT CSE PYQ| BINARY TREE | DATA STR...  
Linked List -    • GATE CS/IT CSE PYQ | LINKED LIST | DATA ST...  
#jatin_gupta_gate