3 votes 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 asked Jan 29, 2018 Ashwin Kulkarni 398 views answer comment Share Follow See all 3 Comments See all 3 3 Comments reply Anu007 commented Jan 29, 2018 reply Follow Share 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 votes 2 votes Ashwin Kulkarni commented Jan 29, 2018 reply Follow Share Sir I too thought same as you but When I ran same type of query it is giving this result. 0 votes 0 votes Ashwin Kulkarni commented Jan 29, 2018 reply Follow Share I think this works on MySQL and won't work on SQL. 0 votes 0 votes Please log in or register to add a comment.