Tampilkan employee id,last name,salary dan salary di kalikan 10% dengan kolom alias “Gaji Baru” SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" from table employees;

SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" from employees;

SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" to employees;

SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" on employees;

SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" from employees;

SQL> select employeeid,lastname,salary,salary*0.1 as "Gaji Baru" from employees;

Hitung lah jumlah karyawan yang Tanggal masuk nya antara 20-09-1988 s/d 06-02-2000

SQL> select count(last_name) from employees where hire_date between '20-09-1988' and '06-02-2000';

SQL> select to count(last_name) from employees where hire_date between '20-09-1988' and '06-02-2000';

SQL> select to table count(last_name) from employees where hire_date between '20-09-1988' and '06-02-2000';

SQL> select from count(last_name) from employees where hire_date between '20-09-1988' and '06-02-2000';

SQL> select count(last_name) from employees where hire_date between '20-09-1988' or '06-02-2000';

Tampilkan last name,salary,dan panjang karakter dengan kolom alias “JML KARAKTER” berdasarkan huruf awal yang di input kan oleh user

select last_name,salary,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%';

select table last_name,salary,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%';

select from last_name,salary,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%';

select on last_name,salary,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%';

select table last_name,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%';

UH SQL Dasar Mengelola Tabel

Computers

1st Grade

Used 63+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

10 questions

Show all answers

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Isikan lah sebuah record ke dalam tabel barang seperti tampilan berikut : KODE_BARANG NAMA_BARANG SATUAN_BARANG STOK_BARANG KPR-1 KULKAS BUAH 20

insert into barang values('KPR-01','KULKAS','BUAH','20');

insert into_barang values('KPR-01','KULKAS','BUAH','20');

insert barang_values('KPR-01','KULKAS','BUAH','20');

insert into barang values(KPR-01,KULKAS,BUAH,20);

insert into barang values(KPR-01,KULKAS,BUAH,20)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Salah satu contoh data manipulation language

ALTER

TABLE

CHAT

SELECT

REPORT

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Ubah lah tabel barang pada kolom nama barang dari TELEVISI menjadi MONITOR

SQL> update to barang set nama_barang='MONITOR' where nama_barang='TELEVISI';

SQL> update from barang set nama_barang='MONITOR' where nama_barang='TELEVISI';

SQL> update barang set nama_barang='MONITOR' where nama_barang='TELEVISI';

SQL> update table barang set nama_barang='MONITOR' where nama_barang='TELEVISI';

SQL>delete from barang set nama_barang='MONITOR' where nama_barang='TELEVISI';

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Hapuslah pada field MONITOR pada kolom nama_barang pada tabel barang

SQL> delete from barang where NAMA_BARANG='MONITOR';

SQL> delete from table barang where NAMA_BARANG='MONITOR';

SQL>delete on barang where NAMA_BARANG='MONITOR';

SQL>delete on table barang where NAMA_BARANG='MONITOR';

SQL> delete from barang where NAMA_BARANG='MONITOR

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Cari kode_brg untuk semua barang yg berhasil dijual oleh lebih dari seorang salesman :

Select kode_brg From Pengiriman Order By kode_brg Having Sum(*)>1

Select kode_brg From Pengiriman Grup By kode_brg Having Sum(kode_sales)>1

Select kode_brg From Pengiriman Order By kode_brg Having Count(*)>1

Select kode_brg From Pengiriman Group By kode_brg Having Count(kode_sales)>1

Select kode_brg From Pengiriman Group By kode_brg Having Count(kode_sales)>=1

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Cari nama salesman yg berlokasi di Jakarta dan status lebih besar dari 30

Select Salesman From nama-sales Where kota=’Jakarta’ and status>30

Select Salesman From nama-sales Where kota=’Jakarta’ or status>30

Select nama_sales From Salesman Where kota=’Jakarta’ or status>30

Select nama_sales From Salesman Where kota=’Jakarta’ and status>30

Select Salesman From namasales Where kota=’Jakarta’ or status>30

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Ubah harga barang dengan kode P2 menjadi 1.5 kali dari harga lama :

Update Barang Set harga=1.5*harga Where kode_brg=’P2’

Replace Barang Set harga=1.5*harga Where kode_brg=’P2’

Replace Barang Where kode_brg=’P2’ Set harga=1.5*harga

Update Barang Where kode_brg=’P2’ Set harga=1.5*harga

Insert Barang Where kode_brg=’P2’ Set harga=1.5*harga

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 Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

10 questions

GRADE 2

Quiz

•

1st - 2nd Grade

10 questions

ICT (Parts of Computer : Mouse)

Quiz

•

1st Grade

12 questions

Grade 1 ICT

Quiz

•

1st Grade

10 questions

Keyboard Movement in Scratch

Quiz

•

1st - 4th Grade

10 questions

POINTER

Quiz

•

1st Grade

10 questions

SQL-мен жұмыс

Quiz

•

1st Grade

15 questions

SQL Programming

Quiz

•

1st - 3rd Grade

10 questions

Berpikir Komputasional-Simplify

Quiz

•

1st - 5th Grade

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

UH SQL Dasar Mengelola Tabel

Isikan lah sebuah record ke dalam tabel barang seperti tampilan berikut : KODE_BARANG NAMA_BARANG SATUAN_BARANG STOK_BARANG KPR-1 KULKAS BUAH 20

Salah satu contoh data manipulation language

Ubah lah tabel barang pada kolom nama barang dari TELEVISI menjadi MONITOR

Hapuslah pada field MONITOR pada kolom nama_barang pada tabel barang

Cari kode_brg untuk semua barang yg berhasil dijual oleh lebih dari seorang salesman :

Cari nama salesman yg berlokasi di Jakarta dan status lebih besar dari 30

Ubah harga barang dengan kode P2 menjadi 1.5 kali dari harga lama :

Tampilkan employee id,last name,salary dan salary di kalikan 10% dengan kolom alias “Gaji Baru”SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" from table employees;

Hitung lah jumlah karyawan yang Tanggal masuk nya antara 20-09-1988 s/d 06-02-2000

Tampilkan last name,salary,dan panjang karakter dengan kolom alias “JML KARAKTER” berdasarkan huruf awal yang di input kan oleh user

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Tampilkan employee id,last name,salary dan salary di kalikan 10% dengan kolom alias “Gaji Baru”
SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" from table employees;