Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
mysql4
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' /* Create a table called NAMES */ CREATE TABLE NAMES(Id int, Name varchar(255), salary varchar(255), mobile varchar(255), designation varchar(255)); /* Create few records in this table */ INSERT INTO NAMES VALUES(1,'BHARTI','22700','70114','helpdesk'); INSERT INTO NAMES VALUES(2,'MUKESH','22700','81300','helpdesk'); INSERT INTO NAMES VALUES(3,'NEHA','28600','81307','helpdesk'); INSERT INTO NAMES VALUES(4,'VISHAL','28600','96677','helpdesk'); INSERT INTO NAMES VALUES(5,'SONU','28600','96508','helpdesk'); /* Display all the records from the table */ SELECT * FROM NAMES; /* Create a table called NIC */ CREATE TABLE NIC(Id int, Name varchar(255), salary varchar(255), mobile varchar(255), designation varchar(255)); /* Create few records in this table */ INSERT INTO NIC VALUES(1,'VIKRANT','40000','12356','TESTER'); INSERT INTO NIC VALUES(2,'KARAN','45000','12353','TESTER'); INSERT INTO NIC VALUES(3,'RAJNISH','45000','12359','TESTER'); INSERT INTO NIC VALUES(4,'GOURAV','42000','12351','TESTER'); INSERT INTO NIC VALUES(5,'JEETESH','43000','12369','TESTER'); /* Display all the records from the table */ SELECT * FROM NIC; ALTER TABLE NIC ADD EMAIL varchar (255); /* Display all the records from the table */ SELECT * FROM NIC; UPDATE NIC SET EMAIL= 'VIKI' WHERE ID ='1' OR ID='3'; /* Display all the records from the table */ SELECT * FROM NIC; SELECT COUNT(EMAIL) AS "EADD" FROM NIC WHERE EMAIL = 'VIKI'; SELECT TOP 2* FROM NAMES; SELECT MIN(salary) AS LOWESTSALARY FROM NIC; SELECT MAX(salary) AS MAXSALARY FROM NAMES; /* Create a table called INFORMATICS */ CREATE TABLE INFORMATICS( Id int, Name varchar(255),contact varchar(255),blood_group varchar(255), join_date varchar(255)); /* Create few records in this table */ INSERT INTO INFORMATICS VALUES (1,'SONU','35467','O+','8_JUNE'); INSERT INTO INFORMATICS VALUES (2,'VISHAL','794873','A+','8_JUNE'); INSERT INTO INFORMATICS VALUES (3,'NEHA','8342','B+','8_JUNE'); INSERT INTO INFORMATICS VALUES (4,'MUKESH','22634','A-','8_JUNE'); INSERT INTO INFORMATICS VALUES (5,'BHARTI','2823749','AB+','8_JUNE'); /* Display all the records from the table */ SELECT * FROM INFORMATICS; SELECT NAMES.Name, INFORMATICS.blood_group, NAMES.salary,INFORMATICS.join_date, NAMES.designation, NAMES.mobile, INFORMATICS.contact FROM NAMES INNER JOIN INFORMATICS ON NAMES.Name=INFORMATICS.Name;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
hello
SinghDestiny
Find gaps in timesheet data between certain hours
bdLojaRoupas
Teacher
Demo
Orders
Query to remove the string between two indexes of delimiters
Object Attributed Mapping Interview Question
Sql flight 1
Please log in to post a comment.