在两个主题中显示具有MINUMUM MARKS的卷筒? [英] Display a roll having MINUMUM MARKS IN TWO SUBJECTS?
问题描述
create table student7(Roll int,English int,Hindi int,Maths int)
insert into student7 values(1,12,15,9)
insert into student7的值(2,23,3,13)
插入student7的值(3,15,12,4)
从student7选择roll其中
maths =(从student7选择min(数学))
AND
英语=(从student7选择min(英语))
上面的查询没有返回任何行。
第二件事,在这里我们将搜索限制在两个主题但是如果我们想显示一个滚动而没有声明任何特定的subject..then
查询不返回任何行
使用代码标签而非粗体
展开 | 选择 | 换行 | 行号
< blockquote>告诉我查询,它检索了一个英文和数学最小标记的卷..............
告诉我查询,它检索了一个英文和数学最小分数的卷..............
你使用的是什么版本的SQL?
- CK
create table student7(Roll int,English int,Hindi int,Maths int)
insert into student7 values(1,12,15,9)
insert into student7 values(2,23,3,13)
insert into student7 values(3,15,12,4)
select roll from student7 where
maths=(select min(maths) from student7)
AND
English=(select min(english)from student7)
Above Query is not returning any row.
Second thing, here we limited our search to two subjects but if we want to display a roll without declaring any particular subject..then解决方案Query is not returning any rowUse code tags and not bold
Expand|Select|Wrap|Line Numbers
Tell me the Query, which retrieved a roll having minimum marks in english and maths..............
Tell me the Query, which retrieved a roll having minimum marks in english and maths..............What version of SQL are you using?
-- CK
这篇关于在两个主题中显示具有MINUMUM MARKS的卷筒?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文