A FREE webinar that will present Learn SQL Server Intuitively. Transact-SQL: The Solid Basics book and will teach you how to: create tables, insert, update and delete data into them select data from existing tables aggregate data will take place Sat, Aug 13, 2016 10:00 AM – 11:00 AM Eastern Daylight Time […]
In a real world scenario, we can sale in our online store on standard or discounted prices. In this exercise we use three tables to demonstrate the zig-zag JOIN:
I am very happy to announce that my first book, dedicated to Microsoft SQL Server from the Learn Intuitively series is now on KickStarter.
When we write a DML query that is using JOINed tables as data source, first we need to understand the way SQL Server is manipulating the data. The clauses in the DML query statement are ordered as follows: SELECT FROM… JOIN WHERE GROUP BY HAVING ORDER BY Behind the scene […]
