Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Week 6 Data Base IET
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table student( studentRegNo int, studentName text, studentAdd text, studentMarks int, ); insert into student values ( 1001, 'Kamran', 'NSR', 500) insert into student values ( 1002, 'Usman', 'SWB', 750) insert into student values ( 1003, 'Sunny', 'PSH', 450) insert into student values ( 1004, 'Asad', 'MDN', 550) insert into student values ( 1005, 'Atif', 'SWT', 800) insert into student values ( 1006, 'Junaid', 'LHR', 800) insert into student values ( 1007, 'Waqar', 'MDN', 440) insert into student values ( 1008, 'Aamir', 'SWB', 745) insert into student values ( 1009, 'Naseer', 'NSR', 590) insert into student values ( 1010, 'Naveed', 'SWB', 670) select *from student; select studentRegNo as StudenIdentification from student; select top 3 * from student; select top 35 percent *from student; select * from student where studentMarks between 450 and 700 ;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
QUAN LY CHUYEN BAY
Merge Sample Code
Movies
Employye
MS SQL Joins
Sql server 2012 features list
ms sql where ,like
dbray
SQL left join
Función Borrar carácter inicial repetido
Please log in to post a comment.