Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

correlated subquery & top & view & derived table & group by

Language: Layout:
View schema
Execution time: 0,05 sec, rows selected: 16, rows affected: 11, absolute service time: 0,25 sec, absolute service time: 0,26 sec 
fork mode |  history  | discussion
   ord_no purch_amt ord_date customer_id salesman_id
1 70002 65,26 05.10.2012 00:00:00 3002 5001
2 70008 5760 10.09.2012 00:00:00 3002 5001
3 70013 3045,6 25.04.2012 00:00:00 3002 5001
4 70005 2400,6 27.07.2012 00:00:00 3007 5001
5 70001 150,5 05.10.2012 00:00:00 3005 5002
6 70007 948,5 10.09.2012 00:00:00 3005 5002
7 70012 250,45 27.06.2012 00:00:00 3008 5002
8 70004 110,5 17.08.2012 00:00:00 3009 5003
9 70003 2480,4 10.10.2012 00:00:00 3009 5003
10 70010 1983,43 10.10.2012 00:00:00 3004 5006
11 70011 75,29 17.08.2012 00:00:00 3003 5007
   avg_tranzac_porto
1 2817,865
   ord_no purch_amt ord_date customer_id salesman_id
1 70002 65,26 05.10.2012 00:00:00 3002 5001
2 70008 5760 10.09.2012 00:00:00 3002 5001
3 70013 3045,6 25.04.2012 00:00:00 3002 5001
4 70005 2400,6 27.07.2012 00:00:00 3007 5001