Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
REGISTRO_ESTUDIANTES
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CREATE TABLE ESTUDIANTES( ID INT NOT NULL, NOMBRE VARCHAR (30) NOT NULL, CORREO VARCHAR (25) NOT NULL, TELEFONO INT NOT NULL, MATRICULA INT NOT NULL, CARRERA VARCHAR (25) NOT NULL PRIMARY KEY (ID)); INSERT INTO ESTUDIANTES(NOMBRE,CORREO, TELEFONO,MATRICULA,CARRERA) VALUES ('PALOMARES GARCIA MARIA FERNANDA', 'PALOMARESGARCIAFERNANDA@GMAIL.COM', '00-55', '00', 'LIC. SISTEMAS COMPUTACIONALES'); SELECT * FROM [ESTUDIANTES];
run
|
edit
|
history
|
help
0
employee table
Insert multiple parent-child records
SQL Server Rank Query Optimization
Me
begginer1
First Query
Fff
20181117
find count of employees with salary more than their managers
20181CSE0041