PracticeDB, Sql Server

PracticeDB

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

select @@version as 'sql server version'

create table EMP(emp_id int ,emp_name varchar(50),emp_gender varchar(50),emp_phone bigint);

insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (101,'Rahul','Male',9765676567);

insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (102,'Shreya','Female',9565676567);

insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (103,'Abhishek','Male',9445676567);

insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (104,'Shruti','Female',9990676567);

insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (105,'Ram','Male',9265676567);

Select * from EMP;

Select TOP 2 * from EMP;

Select TOP 2 *from EMP

select * from EMP where emp_id=102;

select * from EMP where emp_gender='Female' and emp_id=104

select * from EMP where emp_gender='Female' or emp_id=103

Select distinct * from EMP

insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (105,'Ram','Male',9265676567);

Select * from EMP

Select distinct * from EMP

View schema
Execution time: 0,03 sec, rows selected: 31, rows affected: 6, absolute service time: 0,22 sec, absolute service time: 0,22 sec

	sql server version
1	Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) Feb 20 2014 19:20:46 Copyright (c) Microsoft Corporation Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)

	emp_id	emp_name	emp_gender	emp_phone
1	101	Rahul	Male	9765676567
2	102	Shreya	Female	9565676567
3	103	Abhishek	Male	9445676567
4	104	Shruti	Female	9990676567
5	105	Ram	Male	9265676567

	emp_id	emp_name	emp_gender	emp_phone
1	101	Rahul	Male	9765676567
2	102	Shreya	Female	9565676567

	emp_id	emp_name	emp_gender	emp_phone
1	101	Rahul	Male	9765676567
2	102	Shreya	Female	9565676567

	emp_id	emp_name	emp_gender	emp_phone
1	102	Shreya	Female	9565676567

	emp_id	emp_name	emp_gender	emp_phone
1	104	Shruti	Female	9990676567

	emp_id	emp_name	emp_gender	emp_phone
1	102	Shreya	Female	9565676567
2	103	Abhishek	Male	9445676567
3	104	Shruti	Female	9990676567

	emp_id	emp_name	emp_gender	emp_phone
1	101	Rahul	Male	9765676567
2	102	Shreya	Female	9565676567
3	103	Abhishek	Male	9445676567
4	104	Shruti	Female	9990676567
5	105	Ram	Male	9265676567

	emp_id	emp_name	emp_gender	emp_phone
1	101	Rahul	Male	9765676567
2	102	Shreya	Female	9565676567
3	103	Abhishek	Male	9445676567
4	104	Shruti	Female	9990676567
5	105	Ram	Male	9265676567
6	105	Ram	Male	9265676567

	emp_id	emp_name	emp_gender	emp_phone
1	101	Rahul	Male	9765676567
2	102	Shreya	Female	9565676567
3	103	Abhishek	Male	9445676567
4	104	Shruti	Female	9990676567
5	105	Ram	Male	9265676567