SQL Select command

Опубликовано: 08 Июль 2020
на канале: codetyro

This video is about the select command in the SQL language.

This video explains you about logging into SQL server, creating a database, and displaying data from a table through the select command.

Statements to copy paste:

1st set of statements :

create table club
(
GCode Integer(3),
GameName varchar(15),
Number Integer(2),
Fees Integer(5),
StartingDate Date
);

2nd set of statements :

Insert into club values (101,'Carom',2,5000,'2004-01-23');
Insert into club values (102,'Badminton',2,12000,'2003-12-12');
Insert into club values (103,'Table Tennis',4,8000,'2004-02-14');
Insert into club values (104,'Chess',2,9000,'2004-01-01');
Insert into club values (105,'Lawn Tennis',4,25000,'2004-03-19');
Insert into club values (106,'Football',5,20000,'2004-02-23');