dibawah ini syntax yang benar ketika kita ingin mengurutkan baris secara descending...

ORDER BY column_name DESCENDING

Dari gambar tersebut saya ingin menampilkan data orderNumber, orderLineNumber, dan subtotal (quantityOrdered * priceEach) pada tabel customers dan data diurutkan secara descending dari kolom subtotal maka query yang sesuai adalah...

SELECT orderNumber, orderLineNumber, (quantityOrdered * priceEach) AS subtotal FROM customers ORDER BY subtotal DESC

SELECT orderNumber, orderLineNumber, (quantityOrdered * priceEach) AS subtotal FROM customers ORDER BY subtotal DESCENDING

SELECT orderNumber, orderLineNumber, (quantityOrdered * priceEach) AS subtotal FROM customers ORDER BY subtotal ASCENDING

SELECT orderNumber, orderLineNumber, (quantityOrdered * priceEach) AS subtotal FROM customers ORDER BY subtotal

SELECT orderNumber, orderLineNumber, (quantityOrdered * priceEach) AS subtotal FROM customers ORDER BY subtotal ASC

Dari gambar tersebut saya ingin menampilkan data firstname, lastname, dan jobTitle pada tabel employees dimana jobTitle yang ingin ditampilkan hanya "Sales Rep".

SELECT firstname, lastname, jobTitle FROM employees WHERE jobTitle = 'Sales Rep';

SELECT firstname, lastname, jobTitle FROM employees WHERE jobTitle 'Sales Rep';

SELECT firstname, lastname, jobTitle FROM employees WHERE jobTitle : 'Sales Rep';

SELECT firstname, lastname, jobTitle FROM employees WHERE jobTitle = Sales Rep;

SELECT firstname, lastname, jobTitle FROM employees WHERE jobTitle = 'Sales Manager';

Dari gambar tersebut saya ingin menampilkan data firstname, lastname, jobTitle dan officeCode pada tabel employees dengan officeCode 1-3.

SELECT firstname, lastname, jobTitle, officeCode FROM employees WHERE officeCode BETWEEN 1 AND 3;

SELECT firstname, lastname, jobTitle, officeCode FROM employees WHERE officeCode = 1, 2, 3;

SELECT firstname, lastname, jobTitle, officeCode FROM employees WHERE officeCode = 1 OR officeCode = 2 AND officeCode = 3;

SELECT firstname, lastname, jobTitle, officeCode FROM employees WHERE officeCode = 1 AND officeCode = 2 AND officeCode = 3;

SELECT firstname, lastname, jobTitle, officeCode FROM employees WHERE officeCode = 1 AND officeCode = 2 OR officeCode = 3;

Dari gambar tersebut saya ingin menampilkan data firstname, lastname, dan jobTitle pada tabel employees dimana jobTitle yang ingin ditampilkan hanya "Sales Rep".

SELECT firstname, lastname, jobTitle FROM employees WHERE jobTitle = 'Sales Rep';

SELECT firstname, lastname, jobTitle FROM employees WHERE jobTitle 'Sales Rep';

SELECT firstname, lastname, jobTitle FROM employees WHERE jobTitle : 'Sales Rep';

SELECT firstname, lastname, jobTitle FROM employees WHERE jobTitle = Sales Rep;

SELECT firstname, lastname, jobTitle FROM employees WHERE jobTitle = 'Sales Manager';

klausa DISTINCT pada mysql digunakan untuk...

Menghapus duplikat baris dalam hasil query

Mengubah struktur tabel dalam database

Menggabungkan dua tabel dalam satu query

Mengurutkan hasil query berdasarkan kolom tertentu

dibawah ini merupakan syntax sql ketika menggunakan DISTINCT klausa

SELECT DISTINCT column_name FROM table_name;

SELECT DISTINCT column_name table_name;

SELECT column_name DISTINCT FROM table_name;

SELECT DISTINCT FROM column_name table_name;

SELECT column_name FROM table_name;

query yang tepat untuk menampilkan customername, country, dan creditLimit dari tabel customers dengan ketentuan berasal dari country "USA" atau "France" dan memiliki creditLimit lebih dari 100000

SELECT customername, country, creditLimit FROM customers WHERE country IN ('USA', 'France') AND creditLimit > 100000;

SELECT customername, country, creditLimit FROM customers WHERE country = 'USA' OR country = 'France' AND creditLimit > 100000;

SELECT customername, country, creditLimit FROM customers WHERE country = 'USA' AND country = 'France' AND creditLimit > 100000;

SELECT customername, country, creditLimit FROM customers WHERE country = 'USA' OR country = 'France' AND creditLimit < 100000;

SELECT customername, country, creditLimit FROM customers WHERE country = 'USA' AND country = 'France' AND creditLimit < 100000;

SELECT customername, country, creditLimit FROM customers WHERE (country = 'USA' OR country = 'France') AND creditLimit > 100000; query diatas dapat dirubah dengan alternatif lain menghasilkan data yang sama...

SELECT customername, country, creditLimit FROM customers WHERE country IN ('USA', 'France') AND creditLimit > 100000;

SELECT customername, country, creditLimit FROM customers WHERE country = 'USA' OR country = 'France' AND creditLimit > 100000;

SELECT customername, country, creditLimit FROM customers WHERE country = 'USA' AND country = 'France' AND creditLimit > 100000;

SELECT customername, country, creditLimit FROM customers WHERE country = 'USA' OR country = 'France' AND creditLimit < 100000;

Dari gambar tersebut buatkan query untuk menampilkan officeCode, city, dan phone dari tabel offices dimana data yang ditampilkan selain dari country "USA" atau "France" urutkan berdasarkan city

SELECT officeCode, city, phone FROM offices WHERE country NOT IN ('USA', 'France') ORDER BY city

SELECT officeCode, city, phone FROM offices WHERE country = 'USA' OR country = 'France' ORDER BY city

SELECT officeCode, city, phone FROM offices WHERE country NOT IN ('USA', 'France') ORDER BY country

SELECT officeCode, city, phone FROM offices WHERE country != 'USA' AND country != 'France' ORDER BY city

SELECT officeCode, city, phone FROM offices WHERE country IN ('USA', 'France') ORDER BY city

query yang tepat untuk menampilkan employeeNumber, lastName, firstName dari tabel employees dengan lastName diakhiri dengan substring "on"

SELECT employeeNumber, lastName, firstName FROM employees WHERE lastName LIKE '%on'

SELECT employeeNumber, lastName, firstName FROM employees WHERE lastName LIKE 'on_'

SELECT employeeNumber, lastName, firstName FROM employees WHERE lastName LIKE 'on%'

SELECT employeeNumber, lastName, firstName FROM employees WHERE lastName LIKE '%on%'

SELECT employeeNumber, lastName, firstName FROM employees WHERE lastName LIKE 'on'

perbedaan karakter % dan _ pada saat menggunakan operator LIKE adalah...

Karakter % mewakili rangkaian karakter apa pun, sedangkan karakter _ mewakili karakter tunggal apa pun.

Karakter % mewakili setiap karakter tunggal, sedangkan karakter _ mewakili urutan karakter apa pun.

Karakter % mewakili karakter tertentu, sedangkan karakter _ mewakili urutan karakter apa pun.

Karakter % mewakili setiap karakter, sedangkan karakter _ mewakili karakter _.

Dari gambar tersebut query yang tepat untuk menampilkan customerNumber, customerName, creditLimit dari tabel customers data yang ditampilkan hanya 5 customer dengan creditLimit terendah.

SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit ASC LIMIT 5

SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit DESC

SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit DESC LIMIT 5

SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY customerNumber DESC LIMIT 5

SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit ASC

Dari gambar tersebut query yang tepat untuk menampilkan customerNumber, customerName, creditLimit dari tabel customers data yang ditampilkan hanya 5 customer dengan creditLimit tertinggi.

SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit DESC LIMIT 5

SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit DESC

SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY customerNumber DESC LIMIT 5

SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit ASC LIMIT 5

SELECT customerNumber, customerName, creditLimit FROM customers ORDER BY creditLimit ASC

SELECT customername, country, creditLimit FROM customers WHERE (country = 'USA' OR country = 'France') AND creditLimit > 100000; query diatas dapat dirubah dengan alternatif lain menghasilkan data yang sama...

SELECT customername, country, creditLimit FROM customers WHERE country IN ('USA', 'France') AND creditLimit > 100000;

SELECT customername, country, creditLimit FROM customers WHERE country = 'USA' OR country = 'France' AND creditLimit > 100000;

SELECT customername, country, creditLimit FROM customers WHERE country = 'USA' AND country = 'France' AND creditLimit > 100000;

SELECT customername, country, creditLimit FROM customers WHERE country = 'USA' OR country = 'France' AND creditLimit < 100000;

dibawah ini merupakan syntax query yang tepat menggunakan INNER JOIN adalah...

SELECT column1, column2 FROM table1 INNER JOIN table2 ON table1.column = table2.column;

SELECT column1, column2 FROM table1 JOIN table2 ON table1.column = table2.column;

SELECT column1, column2 FROM table1 INNER table2 ON table1.column = table2.column;

SELECT column1, column2 FROM table1 JOIN table2 ON table1.column = table2.column

SELECT column1, column2 FROM table1 INNER JOIN table2 table1.column = table2.column;

dibawah ini merupakan syntax query yang tepat menggunakan LEFT JOIN adalah...

SELECT * FROM tabel_kiri LEFT JOIN tabel_kanan ON tabel_kiri.id = tabel_kanan.id

SELECT * FROM tabel_kiri JOIN tabel_kanan ON tabel_kiri.id = tabel_kanan.id

SELECT * FROM tabel_kiri CROSS JOIN tabel_kanan ON tabel_kiri.id = tabel_kanan.id

SELECT * FROM tabel_kiri RIGHT JOIN tabel_kanan ON tabel_kiri.id = tabel_kanan.id

SELECT * FROM tabel_kiri INNER JOIN tabel_kanan ON tabel_kiri.id = tabel_kanan.id

perbedaan LEFT JOIN dan RIGHT JOIN adalah...

Perbedaan antara LEFT JOIN dan RIGHT JOIN adalah tabel mana yang diambil semua barisnya.

Perbedaan antara LEFT JOIN dan RIGHT JOIN adalah tabel mana yang diambil semua kolomnya.

Perbedaan antara LEFT JOIN dan RIGHT JOIN adalah urutan penggabungan tabel.

Perbedaan antara LEFT JOIN dan RIGHT JOIN adalah cara penggabungan tabel.

Buatkan query untuk menampilkan productCode, productName, textDescription dari tabel products dan tabel productlines dengan productLine di tabel products berelasi dengan productLine di tabel productlines menggunakan INNER JOIN...

SELECT products.productCode, products.productName, productslines.textDescription FROM products INNER JOIN productlines ON products.productLine = productlines.productLine

SELECT products.productCode, products.productName, products.textDescription FROM products JOIN productlines ON products.productLine = productlines.productLine

SELECT products.productCode, products.productName, products.textDescription FROM products LEFT JOIN productlines ON products.productLine = productlines.productLine

SELECT products.productCode, products.productName, products.textDescription FROM products RIGHT JOIN productlines ON products.productLine = productlines.productLine

buatkan query untuk menampilkan orderNumber, status, dan total (quantityOrdered * priceEach) dari relasi tabel orderdetails dengan orders dimana kolom yang berelasi adalah orderNumber menggunakan INNER JOIN group berdasarkan orderNumber...

SELECT orders.orderNumber, orders.status, SUM(orderdetails.quantityOrdered * orderdetails.priceEach) AS total FROM orderdetails INNER JOIN orders ON orderdetails.orderNumber = orders.orderNumber GROUP BY orderdetails.orderNumber

SELECT orderdetails.orderNumber, orders.status, SUM(orderdetails.quantityOrdered * orderdetails.priceEach) AS total FROM orderdetails INNER JOIN orders ON orderdetails.orderNumber = orders.orderNumber GROUP BY orders.orderNumber

SELECT orderdetails.orderNumber, orders.status, SUM(orderdetails.quantityOrdered * orderdetails.priceEach) AS total FROM orderdetails RIGHT JOIN orders ON orderdetails.orderNumber = orders.orderNumber GROUP BY orderdetails.orderNumber

SELECT orderdetails.orderNumber, orders.status, SUM(orderdetails.quantityOrdered * orderdetails.priceEach) AS total FROM orderdetails LEFT JOIN orders ON orderdetails.orderNumber = orders.orderNumber GROUP BY orderdetails.orderNumber

Dibawah ini contoh query dengan menerapkan subquery adalah...

Query yang menggunakan subquery adalah SELECT * FROM table1 WHERE column1 IN (SELECT column2 FROM table2)

Query yang menggunakan subquery adalah SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2)

Query yang menggunakan subquery adalah SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table3)

Query yang menggunakan subquery adalah SELECT * FROM table1 WHERE column1 NOT IN (SELECT column2 FROM table2)

Perbedaan operator UNION dan JOIN adalah...

UNION combines result sets, while JOIN combines rows from tables.

UNION combines rows from tables, while JOIN combines result sets.

UNION combines columns from tables, while JOIN combines rows from tables.

UNION combines result sets based on a condition, while JOIN combines all rows from tables.

syntax query yang digunakan untuk menampilkan baris yang berakhiran huruf "a"

SELECT * FROM table_name WHERE column_name LIKE '%a';

SELECT * FROM table_name WHERE column_name LIKE 'a%';

SELECT * FROM table_name WHERE column_name LIKE '%a%';

SELECT * FROM table_name WHERE column_name LIKE '%a';

syntax query yang digunakan untuk menampilkan baris yang berakhiran huruf "a"

SELECT * FROM table_name WHERE column_name LIKE '%a';

SELECT * FROM table_name WHERE column_name LIKE 'a%';

SELECT * FROM table_name WHERE column_name LIKE '%a%';

SELECT * FROM table_name WHERE column_name LIKE '%a';

Database

Authored by Muhammad Sumadi

Computers

University

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 2 pts

SQL statement yang digunakan untuk memilih data/kolom dari satu atau lebih tabel…

SELECT

INSERT

UPDATE

DELETE

CREATE

MULTIPLE CHOICE QUESTION

1 min • 2 pts

Dari gambar tersebut menunjukan informasi umum dari tabel employees. Jika saya ingin menampilkan data secara berurutan yang terdapat pada kolom lastname, firstname, email dan jobTitle, maka sql query yang tepat adalah…

SELECT firstname, lastname, email, jobTitle FROM employees;

SELECT * FROM employees;

SELECT lastname, firstname, email, jobTitle FROM employees;

SELECT jobTitle, email, firstname, lastname FROM employees;

SELECT * FROM employees WHERE COLUMN lastname, firstname, email, jobTitle;

MULTIPLE CHOICE QUESTION

1 min • 2 pts

untuk menampilkan semua data dari semua kolom yang tersedia dari tabel menggunakan...

SELECT * FROM data_table

SELECT * FROM all_columns

SELECT * FROM table_name

SELECT ALL FROM table_name

SELECT ALL FROM all_columns

MULTIPLE CHOICE QUESTION

1 min • 2 pts

Statement SELECT pada mysql dapat dieksekusi dengan benar tanpa harus menggunakan clausa FROM dan tidak mereferensikan tabel manapun.

TRUE

FALSE

MULTIPLE CHOICE QUESTION

1 min • 2 pts

keyword yang digunakan untuk menetapkan alias pada kolom...

FROM

JOIN

SELECT

WHERE

MULTIPLE CHOICE QUESTION

1 min • 2 pts

untuk dapat mengurutkan baris yang ditampilkan, maka pada query perlu ditambahkan clausa...

JOIN

ORDER BY

WHERE

SELECT

GROUP BY

MULTIPLE CHOICE QUESTION

1 min • 2 pts

Jika kita tidak menambahkan klausa ASC atau DESC setelah penggunaan ORDER BY maka secara default baris yang ditampilkan akan terurut secara...

ascending

random

descending

reverse

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

49 questions

script_programming_part_2+3

Quiz

•

University

50 questions

COM411 Class Test 2

Quiz

•

University

50 questions

Power BI Quiz

Quiz

•

University

48 questions

Google Docs Icebreaker

Quiz

•

University

45 questions

Internet Infrastructure

Quiz

•

11th Grade - University

50 questions

Quiz Pengembangan Perangkat Lunak

Quiz

•

10th Grade - University

50 questions

Big Data Analytics Quiz

Quiz

•

University

50 questions

LONG QUIZ FOR INFO SYSTEM MNGT

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

30 questions

Quiz 1 Review

Quiz

•

University

Database

SQL statement yang digunakan untuk memilih data/kolom dari satu atau lebih tabel…

Dari gambar tersebut menunjukan informasi umum dari tabel employees. Jika saya ingin menampilkan data secara berurutan yang terdapat pada kolom lastname, firstname, email dan jobTitle, maka sql query yang tepat adalah…

untuk menampilkan semua data dari semua kolom yang tersedia dari tabel menggunakan...

Statement SELECT pada mysql dapat dieksekusi dengan benar tanpa harus menggunakan clausa FROM dan tidak mereferensikan tabel manapun.

keyword yang digunakan untuk menetapkan alias pada kolom...

untuk dapat mengurutkan baris yang ditampilkan, maka pada query perlu ditambahkan clausa...

Jika kita tidak menambahkan klausa ASC atau DESC setelah penggunaan ORDER BY maka secara default baris yang ditampilkan akan terurut secara...

dibawah ini syntax yang benar ketika kita ingin mengurutkan baris secara descending...

Dari gambar tersebut saya ingin menampilkan data orderNumber, orderLineNumber, dan subtotal (quantityOrdered * priceEach) pada tabel customers dan data diurutkan secara descending dari kolom subtotal maka query yang sesuai adalah...

ketika mengurutkan data dengan menggunakan klausa ORDER BY pada kolom reports_to secara ascending dan terdapat data NULL pada kolom tersebut, maka data NULL tidak akan ditampilkan.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers