Group by, Sql Server

Group by

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 19, rows affected: 9, absolute service time: 0,22 sec, absolute service time: 0,23 sec

edit mode | history | discussion

  
emp_no
emp_name
salary
hiredate

1
1
Jay
50000
25.09.2012 00:00:00

2
2
ashish
15000
22.07.2003 00:00:00

3
3
shreyas
30000
05.11.2000 00:00:00

4
4
priya
45000
15.04.2010 00:00:00

5
7
mona
35000
05.10.2010 00:00:00


  
dept_no
emp_no
deptname
location

1
11
1
it
mumbai

2
10
3
marketing
thane

3
15
4
abc
kalyan

4
10
2
marketing
nashik


  
(No column name)

1
15000

2
50000

3
45000


  
deptname

1
abc

2
it

3
marketing


  
emp_no

1
4

2
1

3
3

4
2

λ

                                      .NET NoSQL database for rapid development