Mysql syntax — select Top3

-
$topThree = "SELECT score.groupID, SUM(cd + doc + tech + func) AS 總分 
FROM score 
GROUP BY score.groupID LIMIT 3;";

$name = "SELECT score.groupID, IOS110.project_name
FROM score
INNER JOIN IOS110 ON score.groupID = IOS110.groupID;";

$topThreeWithProjectNameSQL = "SELECT IOS110.project_name, score.groupID,
SUM(score.cd + score.doc + score.tech + score.func) AS 總分 
FROM score, IOS110 
WHERE score.groupID = IOS110.groupID 
GROUP BY score.groupID,IOS110.project_name LIMIT 3;";

Comments

Post a Comment

Popular posts from this blog

Go-VSCode -Autocomplete and Auto-import

-
Image
 >goinstall //golang "[go]" :{ "editor.formatOnSave" : true , "editor.codeActionsOnSave" : { "source.organizeImports" : true }, }, "go.testOnSave" : true , "go.lintOnSave" : "package" , "go.formatTool" : "goimports" , "go.testFlags" : [ "-v" ], "go.autocompleteUnimportedPackages" : true , "gopls" : { "experimentalWorkspaceModule" : true , },
Read more

Go - mail

-
Image
  package main import (   "crypto/tls"   "fmt"   gomail "gopkg.in/gomail.v2" ) func main() {   from := "eve@hello.com.tw"   to := "eve@gmail.com"   user := "eve"   pwd := "pwd"   host := `smtp.hello.com.tw`   port := 25   m := gomail.NewMessage()   m.SetHeader( "From" , from)   m.SetHeader( "To" ,to)   m.SetHeader( "Subject" , "Hello!" )   m.SetBody( "text/html" , "Hello <b>Eve</b>!" ) d := gomail.NewDialer(host, port, user, pwd) // x509: certificate signed by unknown authority的解决方法   d.TLSConfig = &tls.Config{InsecureSkipVerify: true }   if err := d.DialAndSend(m); err != nil {     panic(err)   }   fmt.Println( "mail send successfully!" ) } gmail  need to enable POP  IMAP  less secure apps need to enable "less secure apps" on your Google Account var ( from = "coco@gmail.com" to = from user =
Read more