Register

TEST SERIES ( ALL Keyword)

1,269 views
1 votes
1 votes

what will be the output(how many tupples)

User Avatar

2 Answers

0 votes
0 votes
0 tuples will be selected.
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

7 votes
7 votes
1 answer
1
Chhotu asked Dec 24, 2017
1,540 views
SQL keyword ANY and ALL
Hi Guys, In SQL, <condition> ALL evaluates to TRUE if inner query returns no tuples. { X < ALL (empty) == TRUE } <condition> ANY evaluates to FALSE if inner query returns no tuples. { X < ANY (empty) == FALSE } But what is the logical reason behind this ? PS: ping @Krish__, @Anu007, @Ashwin Kulkarni @reena_kandari and @srestha ji.
Hi Guys,In SQL, <condition ALL evaluates to TRUE if inner query returns no tuples. { X < ALL (empty) == TRUE }<condition ANY evaluates to FALSE if inner query returns no...
User Avatar
3 votes
3 votes
2 answers
3
yg92 asked Dec 31, 2016
626 views
SQL <=ALL Query
select studentid, studentname from student where birthyear <=ALL( select birthyear from student); Returns detail of the youngest student Returns detail of oldest student Should not the answer be 2) ?
select studentid, studentname from student where birthyear <=ALL( select birthyear from student);Returns detail of the youngest studentReturns detail of oldest studentSho...
User Avatar
5 votes
5 votes
2 answers
4
yg92 asked Dec 21, 2016
2,069 views
Working of ANY and ALL with empty set
create table stud(id int, grade varchar(20)); insert into stud values(1, 'A'); insert into stud values(2, 'A'); insert into stud values(3, 'B'); insert into stud values(4, 'B'); // Working of ALL ... rerturns NOTHING and NOT a null. Is that an empty set? How is ANY and ALL deciding their output with respect to empty set?
create table stud(id int, grade varchar(20)); insert into stud values(1, 'A'); insert into stud values(2, 'A'); insert into stud values(3, 'B'); insert into stud values(4...
User Avatar
Link Copied!