Database

Ryant Mahardita Undhira Bali

Contoh Tampilan Database Sesuai Key FROM

1. SELECT sno,fname,lname,position FROM `staff` WHERE position='manager'

2. SELECT sno,fname,lname,salary FROM staff WHERE salary <20000

3. SELECT sno,fname,lname,salary FROM staff WHERE salary >30000

4. SELECT sno,fname,lname,salary FROM staf WHERE salary <=30000

5. SELECT sno,fname,lname,salary FROM staff WHERE salary >=20000

6. SELECT sno,fname,lname,position FROM `staff` WHERE position<>'assistant'

7. SELECT sno,fname,lname,salary FROM staff WHERE salary BETWEEN 20000 AND 30000

8. SELECT sno,fname,lname,salary FROM staff WHERE salary NOT BETWEEN 20000 AND 30000

9. SELECT sno,fname,lname,position FROM staff WHERE position IN ('manager', 'assistant')

10. SELECT sno,fname,lname,position FROM staff WHERE position NOT IN ('manager', 'assistant')

11. SELECT sno,fname,lname,position FROM staff WHERE position LIKE '%manager%'

12. SELECT sno,fname,lname,position FROM staff WHERE position NOT LIKE '%assistant%'

13. SELECT sno,fname,lname, salary*2 IS NULL yearssalary FROM staff

14. SELECT sno,fname,lname, salary*2 IS NOT NULL yearssalary FROM staff