Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
EmployeeDetails
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
create table EmployeeDetails ( empid int, fullname varchar(25), mngrid int, dateofjoining date ) insert into EmployeeDetails values(101,'Ankush Taneja',321,'01/31/2014') insert into EmployeeDetails values(121,'Eksha Jain',986,'01/06/2015') insert into EmployeeDetails values(421,'Shubham Dabra',876,'09/07/2018') select * from EmployeeDetails create table EmployeeSalary( empid int, project varchar(10), salary int ) insert into EmployeeSalary values(101,'P1',8000) insert into EmployeeSalary values(121,'P2',10000) insert into EmployeeSalary values(421,'P1',12000) select * from EmployeeSalary select count(empid) Employee_Count , project from EmployeeSalary where project = 'P1' group by project select fullname from EmployeeDetails ED join EmployeeSalary ES on ED.empid=ES.empid where salary between 5000 and 10000 select count(*) Employee_Count , project from EmployeeSalary group by project order by Employee_Count asc select SUBSTRING(fullname,0,charindex(' ',fullname)) FIRSTNAME from EmployeeDetails
View schema
Execution time: 0,03 sec, rows selected: 14, rows affected: 6, absolute service time: 0,23 sec, absolute service time: 0,24 sec
fork mode
|
history
|
discussion