3 3 votes Why this Query is illigal? i.e. Answer given is option C I tried this on W3school IDE it is giving result as option A. Databases sql query self-doubt + – Ashwin Kulkarni 846 views answer comment Share Follow Print See all 3 Comments 3 3 Comments reply Anu007 commented Jan 29, 2018 reply Follow flag B/c min(price) will give one value i.e. min of all price which is assigned to all tupple of with title, i.e. math 30 mathhere error come eng 40 eng here error come hindi 50 hindihere error come we need grouping or single title. 2 2 replyShare Ashwin Kulkarni commented Jan 29, 2018 reply Follow flag Sir I too thought same as you but When I ran same type of query it is giving this result. 0 0 replyShare Ashwin Kulkarni commented Jan 29, 2018 reply Follow flag I think this works on MySQL and won't work on SQL. 0 0 replyShare Please log in or register to add a comment.
