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

Common Table Expression

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 14, rows affected: 19, absolute service time: 0,19 sec, absolute service time: 0,19 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)
   ProductCategory Counter
1 Apparel 3
2 Technology 3
3 Automobile 2
   ProductName ProductPrice
1 iPhone X 1200
2 iPhone X 1200
3 Nike Vapor Shoes 180
4 Ford Focus 18500
5 Ford Focus 18500
6 Ford Focus 18500
7 Astros Cap 80
8 Barcelona Jersey 90
9 Barcelona Jersey 90
10 Samsung Galaxy 850