-
Notifications
You must be signed in to change notification settings - Fork 0
/
talestbuilding.sql
20 lines (20 loc) · 821 Bytes
/
talestbuilding.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
create table news.tallestBuilding(
T_ID int not null ,
T_NAME varchar(45) not null ,
T_LENGTH double not null,
T_COOUNTRY varchar(45) not null,
T_CONSTRUCTEDATE date not null,
T_CONSTRUCTEDATEBY varchar(45)not null ,
T_AREA varchar(45) not null,
primary key (T_ID)
);
delete FROM news.tallestbuilding where T_ID = 5;
SELECT * FROM news.tallestbuilding;
desc news.tallestbuilding;
SELECT distinct T_NAME FROM news.tallestbuilding order by T_LENGTH desc ;
SELECT * FROM news.tallestbuilding;
SELECT * FROM news.tallestbuilding;
update news.tallestbuilding set T_LENGTH=2000 where T_NAME='One World Trade Center';
SELECT distinct T_LENGTH FROM news.tallestbuilding order by T_LENGTH asc limit 5;
SELECT T_NAME FROM news.tallestbuilding limit 5;
SELECT T_LENGTH FROM news.tallestbuilding order by T_LENGTH desc limit 5;