V

@vrs

Stud_Details

SQL
4 years ago
CREATE TABLE Stud_Details( AdmnNo integer(4), RollNo integer(2), Name varchar(20), Percentage decimal(5,2) ); INSERT INTO Stud_Details VALUES(1045, 1, 'Ankita', 98.98); INSERT INTO Stud_Details VALUES(1234, 5, 'Nikita', 100.00); INSERT INTO Stud_D

Trial for CT

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

Practice Test SQL Maths( ) MOD()

SQL
4 years ago
CREATE TABLE Performa ( SCode INTEGER, SchoolName VARCHAR, AnnualFee DECIMAL(12,2) ); INSERT INTO Performa (SCode, SchoolName, AnnualFee ) VALUES ("SCode ","SchoolName ","AnnualFee "),

Practice Test SQL Maths( )

SQL
4 years ago
CREATE TABLE Performa ( RollCode INTEGER, Stud_Name VARCHAR, UT1 DECIMAL(6,2), UT2 DECIMAL(6,2), PB1 DECIMAL(6,2), PB2 DECIMAL(6,2) );

Practice Test SQL Maths( )

SQL
4 years ago
CREATE TABLE Performa ( RollCode INTEGER, Stud_Name VARCHAR, UT1 DECIMAL(6,2), UT2 DECIMAL(6,2), PB1 DECIMAL(6,2), PB2 DECIMAL(6,2) );

SUBSTRING ()

SQL
5 years ago
SELECT SUBSTR('HAKUNA MATATA',-2);

SALES STRING FUNCTIONS

SQL
5 years ago
CREATE TABLE SALES ( InvoNo VARCHAR(8) PRIMARY KEY, CarId VARCHAR, CustId VARCHAR, SaleDate datetime, PaymentMode VARCHAR, EmpId Varchar, SalePrice DECIMAL(10,2) );

Board Patterned Question I (SALES)

SQL
5 years ago
CREATE TABLE SALES ( InvoNo VARCHAR(8) PRIMARY KEY, CarId VARCHAR, CustId VARCHAR, SaleDate datetime, PaymentMode VARCHAR, EmpId Varchar, SalePrice DECIMAL(10,2) );

Round In Inventory

SQL
5 years ago
CREATE TABLE INVENTORY ( CarId VARCHAR PRIMARY KEY, CarName VARCHAR NOT NULL, Price DECIMAL(10,2) NOT NULL, Model VARCHAR, YearManufacturer INTEGER, FuelType VARCHAR );

Round Function @ Work

SQL
5 years ago
CREATE TABLE INVENTORY ( CarId VARCHAR PRIMARY KEY, CarName VARCHAR NOT NULL, Price INTEGER NOT NULL, Model VARCHAR, YearManufacturer INTEGER, FuelType VARCHAR );

Show Selective Rows (records) & Columns of Relation Inventory

SQL
5 years ago
CREATE TABLE INVENTORY ( CarId VARCHAR PRIMARY KEY, CarName VARCHAR NOT NULL, Price INTEGER NOT NULL, Model VARCHAR, YearManufacturer INTEGER, FuelType VARCHAR );

Show Selective Rows (records) of Relation Inventory

SQL
5 years ago
CREATE TABLE INVENTORY ( CarId VARCHAR PRIMARY KEY, CarName VARCHAR NOT NULL, Price INTEGER NOT NULL, Model VARCHAR, YearManufacturer INTEGER, FuelType VARCHAR );

Show Selective Columns of Relation Inventory

SQL
5 years ago
CREATE TABLE INVENTORY ( CarId VARCHAR PRIMARY KEY, CarName VARCHAR NOT NULL, Price INTEGER NOT NULL, Model VARCHAR, YearManufacturer INTEGER, FuelType VARCHAR );

Show Records of Relation Inventory

SQL
5 years ago
CREATE TABLE INVENTORY ( CarId VARCHAR PRIMARY KEY, CharName VARCHAR NOT NULL, Price INTEGER NOT NULL, Model VARCHAR, YearManufacturer INTEGER, FuelType VARCHAR );

Insert Records in Relation Inventory

SQL
5 years ago
CREATE TABLE INVENTORY ( CarId VARCHAR PRIMARY KEY, CharName VARCHAR NOT NULL, Price INTEGER NOT NULL, Model VARCHAR, YearManufacturer INTEGER, FuelType VARCHAR );

Create Relation Inventory

SQL
5 years ago
CREATE TABLE INVENTORY ( CarId VARCHAR PRIMARY KEY, CharName VARCHAR NOT NULL, Price INTEGER NOT NULL, Model VARCHAR, YearManufacturer INTEGER, FuelType VARCHAR );