如何检查学生成绩并将其转换为成绩 [英] How to check and convert Student Mark into Grade

问题描述

你好，先生，我想要更改标记加入，​​我有两个表级和学生标记table.plz建议我sql查询，如何获得它

我的成绩表是

  id  成绩  maxmark   minmark  
  4   A   5 。 00   4  。 10  
 
  5   B   4 。 00   3  。 10  
  6   C   3 。 00   2 。 10  
  7   D   2 。 00   1 。 10  
  8   E   1 。 00   0 . 00  < /   pre  >  

和学生标记表



<前la ng =css> MarksId StudentId 标记
7 3415 4
8 3415 2
9 3415 3

我希望结果标记转换成等级

例如

MarksId StudentId等级

7 3415 B（等级为B，因为B等级表中的等级为4）

解决方案

假设这些是SQL表，并且您尝试在SQL中执行：

  SELECT  sm.MarksId，sm.StudentId，g .Grade  AS 等级 FROM  StudentMarks sm 
  JOIN 等级g  ON  sm.Marks< = g。 MaxMark  AND  sm.Marks> = g.MinMark 

或者更好：

  SELECT  sm.MarksId，sm.StudentId ，g.Grade  AS 成绩 FROM  StudentMarks sm 
  JOIN 等级g  ON  sm.Marks  BETWEEN  g.MinMark  AND  g.MaxMark 

[/ edit]

使用以下查询

 选择  distinct  markid，studid，grade 来自标记
  join  grades1  ON  marks.marks   MaxMArk 和 MinMark 

hello sir i want change mark to garde ,i have two table Grade and Student Marks table.plz suggest me sql query ,how to get it
my grade table is

id  Grade   maxmark     minmark
4   A        5.00        4.10        

5   B       4.00        3.10        
6   C       3.00        2.10       
7   D       2.00        1.10      
8   E       1.00        0.00          </pre>

and student marks table

MarksId   StudentId                     Marks
7         3415                           4     
8         3415                           2      
9         3415                           3       

and i want result mark convert into grade
for example
MarksId StudentId grade
7 3415 B (grade will be B because mark 4 between B Grade in Grade table)

解决方案

Assuming these are SQL tables, and you are trying to do it in SQL:

SELECT sm.MarksId, sm.StudentId, g.Grade AS Grade FROM StudentMarks sm
JOIN Grade g ON sm.Marks <= g.MaxMark AND sm.Marks >= g.MinMark

[edit]
Or better:

SELECT sm.MarksId, sm.StudentId, g.Grade AS Grade FROM StudentMarks sm
JOIN Grade g ON sm.Marks BETWEEN g.MinMark AND g.MaxMark

[/edit]

use below query

select distinct markid,studid,grade from marks
join grades1 ON marks.marks between MaxMArk and MinMark

这篇关于如何检查学生成绩并将其转换为成绩的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！