需要获取SQL查询 [英] need to get sql query

问题描述

朋友们，
我有两个表，如下所示:

Hi friends,
I have two tables as follows :

Table_1

ID    Name
1     AAA
2     BBB
3     ccc

Table_2

ID   Sub   Marks
1    M1    50
1    m2    65
2    M1    89
2    M2    93
3    M1    89
3    M2    56

我需要获得标记的平均值，并且具有最高平均水平的ID才是最重要的.

像..
这样的东西

I need to get average of Marks and ID having highest avg will be on top.

somthing like ..

ID Name     Avg
2  BBB      91
3  CCC      72.5
1  AAA      57.5

知道我怎么能得到这个吗?

任何帮助表示赞赏.
谢谢，
Lok ..

Any idea how can I get this??

Any help appreciated.
Thanks,
Lok..

推荐答案

尝试一下:

Try this:

SELECT DISTINCT Id, Name, AVG(Marks) as Avg
FROM Table_2
JOIN Table_1 ON Table_2.ID = Table_1.ID
ORDER BY Avg

尝试:

SELECT t2.ID, t1.Name, AVG(t2.Marks) AS Average
  FROM Table_2 t2 
  JOIN Table_1 t1 ON t1.ID = t2.ID 
  GROUP BY t2.ID , t1.Name
  ORDER BY Average DESC

尝试访问此链接 www.w3schools.com/ [

try to this link www.w3schools.com/[^]

这篇关于需要获取SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！