Week 6 Data Base IET, Sql Server

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