Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Employee Table
CREATE TABLE Employee ( deptno int, empno int, ename varchar(50) NOT NULL, job varchar(50), salary int , joiningdate date ); INSERT INTO Employee ( deptno, empno, ename, job, salary, joiningdate) VALUES ( 12, 126, 'Rohan', 'Clerk', 5000, '2007-10-16'), ( 15, 127, 'Pankaj', 'Manager', 9300, '2005-01-19'), ( 17, 128, 'Pooja','Analyst', 7000, '2007-12-11'), ( 17, 129, 'Janvi','Analyst', 8000, '2014-08-01'), ( 20, 130, 'Amir', 'Salesman', 4500, '2006-10-27'), ( 23, 131, 'Nihal', 'President', 12000, '2000-06-28'); SELECT * FROM Employee;
run
|
edit
|
history
|
help
0
SQL Server - UK Holiday Calendar Example
Week 6 Data Base IET
Insert With Output Cluase
Demo here
http://connect.bein.net/ar/live-ar/
ss
How to find 2nd highest salary
Window Functions - ROW_NUMBER()
SinghDestiny
TUAN 6 QUANLYDETAI