mysql - Select best score per quiz and sum points leaderboard -

-

मेरे पास MySql तालिका है जो इस तरह दिखती है 

  quiz_id | User_id | अंक -------- + --------- + -------- 1 | 1 | 2 1 | 1 | 7 3 | 1 | 7 2 | 1 | 5 1 2 | 7 2 | 2 | 7 3 | 2 | 2 3 | 2 | 6

उपयोगकर्ता उच्चतम अंक प्राप्त करने की कोशिश कर रहा खेल को फिर से चला सकता है ..

मुझे उपयोगकर्ता द्वारा प्रति क्विज़ में सर्वश्रेष्ठ "अधिकतम" अंक लेने के लिए क्वेरी की ज़रूरत है, और इसे सॉर्ट करें सभी प्रश्नों के योग अंक, और इसे इस तरह देखने के लिए करें: 

  user_id | एसएम (अंक) -------- + -------- 2 | 20 1 | 19

मैंने इसके साथ इसका दूसरा भाग करने की कोशिश की है 

  का चयन करें user_id, SUM (points) से Quiz_list GROUP BY user_id ORDER BY SUM ( अंक) डीईएससी

मुझे वाकई बहुत सराहना होगी अगर कोई मुझे दिखा सकता है कि यह कैसे एसक्यूएल क्वेरी के रूप में दिखना चाहिए।

मुझे लगता है कि आपको अधिकतम () प्राप्त करने के लिए एक subquery की जरूरत है और फिर sum () :

< Pre-> user_id का चयन करें, sumpoints के रूप में sumump (points), user_id (quote_not), quiz_id, quiz_id द्वारा quiz_id समूह के अंक के रूप में (user_id, quiz_id, अधिकतम)

एसक्यूएल बेडल:


Comments

Post a Comment

Popular posts from this blog

HTML/CSS - Automatically set height width from background image? -

-
Long time ... I do not think it's possible, but I'm shocked before! I tag anchor tags, all of which are background images, all 300px wide but their height is all the difference, is it really set to do without typing altitude? Is it to set the dimensions of BG URL? Thank you! I do not think people understand - my mistake is to hurry the question. Here is the code as an example: # ago -1 {width: 300px; Height: 410px; Background: url ('/ image-1.jpg');} # East -2 {width: 300px; Height: 420px; Background: url ('/ image-2.jpg');} # Pre-3 {width: 300px; Height: 430px; Background: url ('/ image-3.jpg');} # Pre-4 {width: 300px; Height: 440px; Background: url ('/ image-3.jpg');} & lt; A href = "#" id = "ex-1" & gt; & Lt; / A & gt; & Lt; A href = "#" id = "ex-2" & gt; & Lt; / A & gt; & Lt; A href = "#" id = "pre-3" & gt; & Lt; / A & gt...
Read more

php - Mysql Show Process - Sleep Commands and what to do -

-
I am thinking that there is something that I can do better so that my process list should start with the command with MySQL Be clear Currently I am looking for a lot: 17325 user_a localhost db_1 sleep 1132 NULL 17464 user_a localhost db_1 sleep 1124 NULL 17983 user_a localhost db_1 sleep 1078 null 18113 user_a localhost db_1 sleep 1068 NULL 18207 user_a localhost db_1 sleep 1060 NULL 18231 user_a localhost db_1 sleep 1058 NULL 18353 user_a localhost db_1 sleep 1047 NULL 18447 user_a localhost db_1 sleep 1040 null 18489 user_a localhost db_1 sleep 1036 NULL 23408 user_a localhost db_1 sleep 637 NULL Something in my phpscript is that I want to clean it Can i The script looks like: Select the ID from $ q = 'db_1 where fkId = 2'; $ Ar = mysql_query ($ q); ($ Line = mysql_fetch_array ($ qr)) {echo ($ row ['id'];} Thanks in advance! I'm guessing that when you have 10 threads, you're constantly using the connectio...
Read more

list Class in C++ -

-
I am working on a program that is considered to be reading the content of a file in the list of links "hypercard stack "(I have listed special). I know that there is a list in the C ++ standard library, but since I've never worked with the standard library before, I do not know how to make it work with this particular problem for. Any code I have received here has been successful in collecting bits of online bits and online tutorials together. My .h file: // program6.h #include & lt; Iostream & gt; # Include & lt; Fstream & gt; #include & lt; String & gt; # Include & lt; List & gt; using namespace std; Square node {public: node (); Node (four code, integer number, string data); Node (node ​​and node); ~ Node (); Bool readFile (); Zero set next (node ​​* next); Zero print (); Private: four codes; Int Num; String data; Node * next; }; My implementation file: // program6.cpp #include "program6.h" #include & lt;...
Read more