Dinesh's Blog :::: Being Compiled ::::

Showing posts with label Sub Queries. Show all posts
Showing posts with label Sub Queries. Show all posts
Thursday, August 4, 2016

Generate aggregates for different levels in the same queries without using sub queries

›
While analyzing a query written for a report, I noticed a query that has been written for getting aggregated values on a same column but u...
Friday, February 14, 2014

Types of SQL Server Sub Queries: Self-Contained, Correlated, Scalar, Multi-Valued, Table-Valued

›
A Sub query is a SELECT statement that is embedded to another query. Or in other words, a SELECT statement that is nested to another SELECT....
2 comments:
›
Home
View web version

About Me

My photo
Dinesh Priyankara
Colombo, Sri Lanka
Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and business intelligence related projects. He is the Founder/Principal Architect of dinesQL (Pvt) Ltd and he consults, teaches and runs training programs on data related solutions and subjects.
View my complete profile
Powered by Blogger.