GROUP BY : The GROUP BY clause is used in conjunction with the SELECT Statement and Aggregate functions to group rows together by common column values. SELECT with GROUP BY Syntax : SELECT columns FROM table_name WHERE condition GROUP BY column_name(s); (Here above "condition" is Optional in above query). In "personal" table, there are 6 columns named id, name, percentage, age, gender, city. In "personal" table, column name "id" is PRIMARY KEY and column name "city" is FOREIGN KEY. In "courses" table, there are 2 columns named course_id and course_name. In "courses" table, column name "course_id" is PRIMARY KEY. In "city" table, there are 2 columns named cid and cityname. In "city" table, column name "cid" is PRIMARY KEY. SELECT with GROUP BY with Two Tables Syntax : SELECT columns FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name WHERE condition GROUP B...
<?php class Base { public function abc () { echo "ABC method from Base class." ; } } //The trait method(Here, abc() Method) will get priority compared to Parent class Method(Here, abc() Method) trait Test { public function abc () { echo "ABC method from test trait." ; } } class Child extends Base { use Test ; public function abc () { echo "ABC method from Child class." ; } } $obj = new Child (); $obj -> abc ();
Comments
Post a Comment