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

Flutter - "PlatformException(no_fragment_activity, local_auth plugin requires activity to be a FragmentActivity., null)"

-
Image
package co.et.keys import androidx.annotation.NonNull ; import io.flutter.embedding.android.FlutterFragmentActivity import io.flutter.embedding.engine.FlutterEngine import io.flutter.plugins.GeneratedPluginRegistrant class MainActivity: FlutterFragmentActivity() { override fun configureFlutterEngine(@NonNull flutterEngine: FlutterEngine) { GeneratedPluginRegistrant.registerWith(flutterEngine) ; } } <uses-permission android :name ="android.permission.USE_BIOMETRIC" /> refer 1 refer2  
Read more

Dart syntax - initSate,Build,deactive, Dispose

-
 ☝ initSate(){ super.initSate   //放置一旦載入statefulwidget後就不需一直更新的物件。 } 如字面的意思in it sate. 此功能好比statefulwidget 裡面的statelesswidget。   Called only once when the widget is created，只會執行一次，不像build() 一變動就自毀後重建。 ☝Build(BuildContext context) { //放置載入後每次有任何變動就需更新的物件。 }          - Build the widget tree         -A build is triggred every time we use setState() that re-triggre build(). ☝ deactive() {super.deactive // 放置當statefulwight自毀換頁前跟著毀的物件。例如:釋放記憶空間。 } ☝Dispose()          - When the widget/state object is removed.
Read more