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

Showing posts with label TOP. Show all posts
Showing posts with label TOP. Show all posts
Friday, May 27, 2016

SET ROWCOUNT overrides TOP?

›
While I was going through an implemented set of codes, I noticed that ROWCOUNT is heavily used (of course, it is an old implementations) a...
Monday, July 13, 2015

MDX Top function

›
If we need get Top n  records from a relational database table, we simply use SELECT TOP (n)....  But how do you do the same with Multi-di...
Sunday, April 24, 2011

TOP WITH TIES: Have you shown your TOP 10 Customers properly?

›
Think about a scenario where you have to show your top 10 customers based on their purchases. If the record set is as below; and if you ...
Monday, February 22, 2010

Understanding the TOP and TABLESAMPLE operators

›
Result set can be filtered in many ways. Most common ways is, using the 3rd primary property of the SQL SELECT statement which is the WHERE ...
›
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.