Select Examples

SELECT * FROM PART;

Selects all column values for all rows

SELECT PARTNO, PNAME FROM PART

WHERE PRICE >= 0.2;

Selects rows where price >= .2

SELECT PARTNO, PNAME FROM PART

WHERE PNAME LIKE (’CAR%');

Selects rows where pname has a value starting with CAR

PART