Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Group by
create table emp(emp_no integer,emp_name varchar (30),salary integer,hiredate date); insert into emp values(1,'Jay',50000,'2012-09-25'),(2,'ashish',15000,'2003-07-22'),(3,'shreyas',30000,'2000-11-05'),(4,'priya',45000,'2010-04-15'),(7,'mona',35000,'2010-10-05'); select * from emp; create table dept(dept_no integer,emp_no integer ,deptname varchar(30),location varchar(30)); insert into dept values(11,1,'it','mumbai'),(10,3,'marketing','thane'),(15,4,'abc','kalyan'),(10,2,'marketing','nashik'); select * from dept; Select min(salary)from emp e,dept d where e.emp_no=d.emp_no group by dept_no; Select deptname from dept group by deptname; Select emp_no from dept order by deptname;
run
|
edit
|
history
|
help
0
for xml path concatenation ordered by seqno
aa
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries samples...
Employee database
Basic Except
Lab 4
20181CSE0041
bc160402152
Task_7_Final
Return a single column that matches a parameter