Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
deepu
--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;
run
|
edit
|
history
|
help
0
SO_20171230_SqlServer
SQL Directives Order of Execution
TESTE PLATAFORMA
All the k-mers/n-grams
Display Multiple Rows as a single Line
QLDT_TUAN 7
do several updates at once
islands and gaps problem
TO find max marks of students
sql test