Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
employee table
create table employee ( e_id int not null, e_name varchar(20), e_salary int, e_age int, e_gender varchar(20), e_dept varchar(20), primary key (e_id)); insert into employee values(1, 'sam' , 95000 , 45 , 'male' , 'operations' ); insert into employee values (2, 'bob' , 80000 , 21 , 'male' , 'support' ); insert into employee values(3, 'anne' , 125000 , 25 , 'female' , 'analytics' ); insert into employee values(4, 'julia' , 73000 , 30 , 'female' , 'analytics' ); insert into employee values(5, 'matt' , 159000 , 33 , 'male' , 'sales' ); insert into employee values(6,'jeff' , 112000 , 27 , 'male' , 'operations' ); select * from employee; select e_name from employee; select e_gender from employee; select distinct(e_gender) from employee;
run
|
edit
|
history
|
help
0
Arif Secoond Query
Función Borrar carácter inicial repetido
Crea, confirma y despliega tablas
Demo
Rno 37 boat
Dividing runs by time stamp
Query through an error in Sql Server 2008 r2
OUTER JOIN
Add JSON"Valuetypes to XML Nodes using SQL
practice sql_12AUG