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

parameters_in_procedure-join&correlated sub-query content

Language: Editor: Layout:
View schema
Execution time: 0,08 sec, rows selected: 15, rows affected: 18, absolute service time: 0,28 sec, absolute service time: 0,28 sec   
edit mode |  history  | discussion
   salesman_id salesman_name customer_id order_id amount ord_date
1 5001 James Hoog 3002 70002 65,26 05.10.2012 00:00:00
2 5001 James Hoog 3002 70008 5760 10.09.2012 00:00:00
3 5001 James Hoog 3002 70013 3045,6 25.04.2012 00:00:00
4 5001 James Hoog 3007 70005 2400,6 27.07.2012 00:00:00
5 5002 Nail Knite 3005 70001 150,5 05.10.2012 00:00:00
6 5002 Nail Knite 3005 70007 948,5 10.09.2012 00:00:00
7 5002 Nail Knite 3008 70012 250,45 27.06.2012 00:00:00
8 5003 Ogrinja Alexandru 3009 70003 2480,4 10.10.2012 00:00:00
9 5003 Ogrinja Alexandru 3009 70004 110,5 17.08.2012 00:00:00
10 5005 Pit Alex 3001 70009 270,65 10.09.2012 00:00:00
11 5006 Mc Lyon 3004 70010 1983,43 10.10.2012 00:00:00
12 5007 Paul Adam 3003 70011 75,29 17.08.2012 00:00:00