K

@Kushagra_13

SQL ......

SQL
4 years ago
-- create a table CREATE TABLE Airline ( pilot id INTEGER PRIMARY KEY, name TEXT NOT NULL, plane number INTEGER NOT NULL ); -- insert some values INSERT INTO Airline VALUES (1236, 'Ryan', '13967'); INSERT INTO Airline VALUES (2645, 'Juli', '238947'); INSERT INTO Airline VALUES (3476 , 'Robin','547954');

SQL command for Update

SQL
4 years ago
-- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL, phone INTEGER NOT NULL ); -- insert some values INSERT INTO students VALUES (1, 'Ryan', 'M', '12345'); INSERT INTO students VALUES (2, 'Joanna', 'F','1245');

SQL code for Order by command

SQL
4 years ago
-- create a table CREATE TABLE customer ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, country TEXT NOT NULL ); -- insert some values INSERT INTO customer VALUES (1, 'Ryan', 'America'); INSERT INTO customer VALUES (2, 'Joanna', 'France'); INSERT INTO customer VALUES (3, 'Tom', 'United Kindom');

SQL coding for where command

SQL
4 years ago
-- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, country TEXT NOT NULL ); -- insert some values INSERT INTO students VALUES (1, 'Bheem', 'INDIA'); INSERT INTO students VALUES (2, 'Radha', 'United kingdom'); INSERT INTO students VALUES (3, 'Juli', 'Germany');

SQL coding for Distinct statement

SQL
4 years ago
-- create a table CREATE TABLE customer ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, country TEXT NOT NULL ); -- insert some values INSERT INTO customer VALUES (1, 'Rahul', 'Varanasi'); INSERT INTO customer VALUES (2, 'Justin', 'Germany'); INSERT INTO customer VALUES (3, 'Krish', 'United state of America');

SQL coding

SQL
4 years ago
-- create a table CREATE TABLE patient ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL ); -- insert some values INSERT INTO patient VALUES (1, 'Ron', 'M'); INSERT INTO patient VALUES (2, 'Sita', 'F'); INSERT INTO patient VALUES (3, 'JACK', 'M');