1 / 10

MENAMPILKAN DATA DARI SATU TABEL

Learn how to create databases and tables, insert records, query data efficiently using SELECT statements, comparison and logical operators in SQL. Practice examples provided.

lstrong
Télécharger la présentation

MENAMPILKAN DATA DARI SATU TABEL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MENAMPILKAN DATA DARI SATU TABEL OMAN SOMANTRI, S.KOM

  2. Pembuatan Database & Tabel • Buat Database : “ Nama_Sendiri “ • Buatlah Tabel dengan nama “ products “

  3. Pengisian Data Record

  4. Querying the Database SELECT

  5. SELECT without Table

  6. Comparison Operators

  7. String Pattern Matching - LIKE and NOT LIKE

  8. Logical Operators - AND, OR, NOT, XOR You can combine multiple conditions with boolean operators AND, OR, XOR. You can also invert a condition using operator NOT. • SELECT * FROM products WHERE quantity >= 5000 AND name LIKE 'Pen %'; • SELECT * FROM products WHERE quantity >= 5000 AND price < 1.24 AND name LIKE 'Pen %'; • SELECT * FROM products WHERE NOT (quantity >= 5000 AND name LIKE 'Pen %');

  9. IN, NOT IN • SELECT * FROM products WHERE name IN ('Pen Red', 'Pen Black'); BETWEEN, NOT BETWEEN • SELECT * FROM products WHERE (price BETWEEN 1.0 AND 2.0) AND (quantity BETWEEN 1000 AND 2000);

More Related