The Gateway to Computer Science Excellence
+2 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.

in Databases by Boss (18.8k points) | 116 views

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.


Sir I too thought same as you but When I ran same type of query it is giving this result.

I think this works on MySQL and won't work on SQL.

Please log in or register to answer this question.

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,370 answers
105,272 users