SQL

Question 1

How do you order by in SQL

Answer 1

ORDER BY DataPublished Desc (autimatically does it by ascending if you dont put desc)

Question 2

How to create a table

Answer 2

CREATE TABLE TableName
(
Attribute1 INTEGER NOT NULL, PRIMARY KEY
Attribute2 VARCHAR(20) NOT NULL
)

Question 3

What do you have to include when making a table

Answer 3

Wether it is a primary key, its data type and wether it must be filled in (“not null”)

Question 4

Obscure data types

Answer 4

CHAR(n), VARCHAR(n), DATE,TIME,CURRENCY

Question 5

N in char v N in varchar

Answer 5

In char it means it must be that length but in varchar that is just the max length

Question 6

Alter adding column

Answer 6

Alter Table TableName
ADD attributeX and their datatypesD

Question 7

Alter deleting collumn

Answer 7

ALTER table tablename
drop column attribute x

Question 8

Alter modyfying data type of column

Answer 8

ALTER TABLE tablename
modify column attribute x newdatatype

Question 9

Insert new record into database

Answer 9

INSERT INTO (Column 1m column 2 )
VALUES( value1,value2)

Question 10

Update record in data base

Answer 10

Update tablename
set column 1=x, column2=y
wheree column x=value

Question 11

Delete row from table

Answer 11

Delete from table
where columnx=value

Question 12

nested select

Answer 12

Select firstName, secondName
FROM people
where favfoodID=
(select foodID
FROM foods
where foodname=”cheese”)

Question 13

Join

Answer 13

Select people. firstname, people, secondmame
from people
join foods on people.favouritefoodID=foods.foodid
where foods.foodname=”cheese”