Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
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
Please
log in
to post a comment.
SQL_Joins_RankingFunctions
Update Temp table to Insert node in XML data using SQL
NAMES CODE
Running Total
Manish_Sql_updated
Time Difference Calculation (amended v2)
Solution 2
sql to search database objects' definitions for text
Miglior film animato
Names
Please log in to post a comment.