Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result set to a specified number of rows or percentage of rows”. The following is the […]
2019-06-04
4,292 reads
2015-10-22
1,822 reads
There are times when you don’t what to return a complete set of records. When you have this kind of requirement to only select the TOP X number of items Transact SQL (TSQL) has the TOP clause to meet your needs. In this article Greg Larsen explores how to select a subset of data from a record set.
2015-04-16
9,580 reads
2014-05-09
2,198 reads
2013-06-04
2,391 reads
2013-05-30
2,134 reads
2009-03-18
5,225 reads
2008-07-03
10,685 reads
By MUTHUKKUMARAN KALIYAMOORTHY
How to read execution plan to improve poorly... [[ This is a content summary only....
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
By Jen McCown
There’s a very good reason to do most of your DBA work using T-SQL,...
Hello, I have a SQL 2017 and I want to use business intelligence development...
hi all, as you can see in attachment sql take 122 giga memory. and...
Hi all, this is my first post here and I've been looking and trying...
Ask SSC