FUNGSI AGREGAT

Assessment
•
SITI Moe
•
Computers
•
•
2 plays
•
Easy
Student preview

8 questions
Show answers
1.
Multiple Choice
Mengembalikan jumlah nilai medan tertentu
MAX
MIN
SUM
AVG
2.
Multiple Choice
Mengembalikan nilai terendah medan tertentu
MIN
MAX
AVG
COUNT
3.
Multiple Choice
Mengembalikan jumlah bilangan rekod
SUM
COUNT
MIN
MAX
4.
Multiple Choice
Menyenaraikan maklumat MEDAN dalam susunan MENAIK mengikut nama barang.
ORDER BY namabarang DESC
GROUP BY namabarang
ORDER BY namabarang ASC
HAVING namabarang
5.
Multiple Choice
SQL untuk mencapai atau memaparkan data dalam jadual
INSERT INTO
CREATE TABLE
SELECT
UPDATE
Explore all questions with a free account
Find a similar activity
Create activity tailored to your needs using
SQL: Fungsi Agregat

•
5th Grade
Sains Komputer Tingkatan 5 - 2.1.6 Fungsi Agregat

•
10th - 12th Grade
SK F5 (2.1.6 Fungsi Agregat)

•
10th Grade - University
Sains Komputer SQL Tingkatan 5

•
6th Grade - University
PBD SK T5 - 2.1 Bahasa Pertanyaan Berstruktur

•
1st Grade - Professio...
ULANGKAJI TRIAL 2019

•
5th Grade
Fungsi Agregat

•
11th Grade
STM2013: TOPIK 2

•
University