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
Varchar to Binary and vice-versa
mywall
store
db3
exp7
query
tesing
Hotel BD
TRY_SQL
how-to-assign-a-random-value-in-a-select-statement-in-sqlserver