Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Ggg
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table book(isbn varchar(10),title varchar(10),pub_year varchar(10),unit_price varchar(10),author_name varchar(10),publisher_name varchar(10)); insert into book values(1001,'oracle',2004,399,'arora','phi'); insert into book values(1002,'dbms',2004,400,'basu','technical'); insert into book values(2001,'dos',2003,250,'sinha','nirali'); insert into book values(2002,'adbms',2004,450,'basu','technical'); insert into book values(2003,'unix',2000,300,'kapoor','scitech'); select * from book; Select author_name from book; Select publisher_name from book; Select title, unit_price * 10 from book; select title from book where pub_year='2004'; Select title from book where unit_price between 300 and 400;
run
|
edit
|
history
|
help
0
Suikwan tests
Libros
TEST 1
persons
db
Ejercicios de SQL (I)9
llaves vistas (alumnos) Karen
Week 6 Data Base IET
Exp8Q2
Adding, subtracting, rounding and calculating differences