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

TRY_SQL

Language: Layout:
View schema
Execution time: 0,05 sec, rows selected: 15, rows affected: 35, 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)
   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)
   LastName (No column name) Total
1 Ace 5,7 Baseball
2 Ashli 5,7 Baseball
3 Cruise 5,7 Baseball
4 Ace 99,9 Bat
5 Ashli 99,9 Bat
6 Brontee 99,9 Bat
7 Catton 199,8 Bat
8 Ashli 28,6 Football cap
9 Brontee 28,6 Football cap
10 Cruise 14,3 Football cap
11 Ace 21,6 socks
12 Ashli 10,8 socks
13 Catton 10,8 socks