3 votes 3 votes 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) ? Databases sql databases + – yg92 asked Dec 31, 2016 retagged Aug 5, 2017 by Arjun yg92 593 views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply shayal chhabra commented Jan 2, 2017 reply Follow Share Ans is 1. 0 votes 0 votes umang_16 commented Jan 29, 2017 reply Follow Share What if more than one student are having same birthyear ? in dat case it will not return youngest student only...whereas a group of all who are youngest. ??? 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes yes if birthyear is stored as number with size 4 Sanjay Sharma answered Dec 31, 2016 Sanjay Sharma comment Share Follow See 1 comment See all 1 1 comment reply gatesjt commented Jan 26, 2017 reply Follow Share Sir, Can u please explain more ? i didn't understand. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes Yes, if A's birthyear is less than B's. Then A is older than B. Therefore the answer is 2nd i.e. returns detail of oldest students. nadeshseen answered Sep 14, 2019 nadeshseen comment Share Follow See all 0 reply Please log in or register to add a comment.