CREATE TABLE STUDENT
(STUDENT_ID INTEGER NOT NULL UNIQUE, SURNAME CHAR (25) NOT NULL,
NAME CHAR(10 ) NOT NULL ,
STIPEND INTEGER,
KURS INTEGER,
CITY CHAR(15), BITHDAY DATE;
Jadvalda kalit maydonlarni ishlatish komandasi kuyidagicha bo‘ladi
CREATE TABLE STUDENT
( STUDENT_ID INTEGER PRIMER KEY , SURNAME CHAR (25) NOT NULL,
NAME CHAR(10 ) NOT NULL ,
STIPEND INTEGER,
KURS INTEGER,
CITY CHAR(15), BITHDAY DATE,
UNIV_ID INTEGER);
SELECT operatori
SELECT (tanlash) SQL tilining eng muxim va kup ishlatiladigan operatori xisoblanadi. U ma’lumotlar bazasi jadvalidan axborotlarni tanlab olish uchun muljallangan. SELECT operatorini sintaksisi quyidagicha:
SELECT [ALL/DISTINCT] <atributlar ruyxati> FROM <jadvallar ruyxati> [WHERE <tanlash sharti>] [ORDER BY < atributlar ruyxati >] [GROUP BY < atributlar ruyxati >] [HAVING <shart> ]
[UNION