Skip to content

Instantly share code, notes, and snippets.

@ArCiGo

ArCiGo/1. Example. WHERE.sql

Last active May 19, 2019 21:41
Show Gist options
  • Save ArCiGo/eb629df7fc4ed432a51310706764fbe1 to your computer and use it in GitHub Desktop.
Save ArCiGo/eb629df7fc4ed432a51310706764fbe1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
1. Example. WHERE.sql
SELECT *
FROM [ORDER] ord
WHERE ord.CustomerId = 85 AND ord.OrderDate = '20131112';
GO
/** Output **/
Id OrderDate OrderNumber CustomerId TotalAmount
----------- ----------------------- ----------- ----------- ---------------------------------------
492 2013-11-12 00:00:00.000 542869 85 240.00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment