Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SinghDestiny
CREATE TABLE EMP (EMPNO INT, EMPNAME CHAR(20), JOB CHAR(20), HIREDATE CHAR(20), SAL FLOAT, COMM FLOAT, DEPT_NO INT); INSERT INTO EMP (EMPNO,EMPNAME,JOB,HIREDATE,SAL,COMM,DEPT_NO) VALUES (320,'SUMIT KUMAR','ANALYST','14-MARCH-2019',50000,600,48), (322,'GITESH KUMAR','ASSISTANT MANAGER','14-APRIL-2019',40000,400,45), (305,'MUKESH KUMAR','PRESIDENT','10-MARCH-2010',100000,6008,01), (323,'HARSH','ANALYST','14-OCTOBER-2017',45000,1500,09), (329,'HARSHIT','ASSOCIATE ANALYST','14-MARCH-2019',40000,900,89), (31,'ARVIND','HR','14-JUNE-2010',49000,2000,51), (309,'SAJAL','SENIOR ANALYST','14-NOVEMBER-2009',40000,900,69); INSERT INTO EMP (EMPNO,EMPNAME,JOB,SAL) VALUES (320,'NAVEED','CLERK',50000); select * from emp;
run
|
edit
|
history
|
help
0
PIVOT AND UNPIVOT USING XML PARSING
UNPIVOT
SQL
CREATE DATABASE
SQL for beginners( defined with errors while enforcing constraints)
get date part from datetime
QLSV
store2
Kill all connections to given database
Preppin Data Challenge - Week 8