Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

SQL Test

Language: Layout:
View schema
Execution time: 0,05 sec, rows selected: 13, rows affected: 20, absolute service time: 0,2 sec, absolute service time: 0,2 sec 
edit mode |  history  | discussion
   sql server version
1 Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) Feb 20 2014 19:20:46 Copyright (c) Microsoft Corporation Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)
   account_name currency Total invoice Amount
1 ABC Supply USD 2592,81
2 Board Manufacturing NULL NULL
3 Custom Paint USD 5240,00
4 Direct Line USD 1948,40
5 Essential Systems GBP 116,99
6 Master Corporation USD 2168,91
7 Yellow Squared USD 13409,42
   account_number account_name address city state zip country
1 579 Board Manufacturing 564 W. Holly St Boston MA 2120 US
   account_number account_name address city state zip country
1 579 Board Manufacturing 564 W. Holly St Boston MA 2120 US
   Invoice_Month Invoice_Amount
1 April 15595,7435
2 May 8580,4632
3 June 1338,9300