Skip to content

Instantly share code, notes, and snippets.

@ArCiGo

ArCiGo/3. Example. WHERE.sql

Last active May 19, 2019 21:41
Show Gist options
  • Save ArCiGo/5f6c7b499ab48f357dee297cf38f2f33 to your computer and use it in GitHub Desktop.
Save ArCiGo/5f6c7b499ab48f357dee297cf38f2f33 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
3. Example. WHERE.sql
SELECT *
FROM [ORDER] ord
WHERE ord.CustomerId IN(85, 14, 1);
GO
/** Output **/
Id OrderDate OrderNumber CustomerId TotalAmount
----------- ----------------------- ----------- ----------- ---------------------------------------
1 2012-07-04 00:00:00.000 542378 85 440.00
7 2012-07-11 00:00:00.000 542384 14 625.20
27 2012-08-06 00:00:00.000 542404 85 538.60
48 2012-09-02 00:00:00.000 542425 85 121.60
123 2012-12-03 00:00:00.000 542500 14 1174.00
272 2013-04-28 00:00:00.000 542649 14 2356.00
396 2013-08-25 00:00:00.000 542773 1 1086.00
445 2013-10-03 00:00:00.000 542822 1 878.00
455 2013-10-13 00:00:00.000 542832 1 330.00
484 2013-11-06 00:00:00.000 542861 14 1990.00
490 2013-11-11 00:00:00.000 542867 85 139.80
492 2013-11-12 00:00:00.000 542869 85 240.00
499 2013-11-19 00:00:00.000 542876 14 2311.70
588 2014-01-15 00:00:00.000 542965 1 851.00
705 2014-03-16 00:00:00.000 543082 1 491.20
719 2014-03-20 00:00:00.000 543096 14 1255.60
764 2014-04-09 00:00:00.000 543141 1 960.00
782 2014-04-16 00:00:00.000 543159 14 1286.80
794 2014-04-22 00:00:00.000 543171 14 1887.00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment