TOP n [PERCENT]
With the help of this we can limit the result set.
In the case of TOP, by default it will return the n number of rows of total result set but if we use PERCENT with TOP then it will return the n PERCENT record of total result set.
PERCENT is optional with TOP.
For example:-
With the help of this we can limit the result set.
In the case of TOP, by default it will return the n number of rows of total result set but if we use PERCENT with TOP then it will return the n PERCENT record of total result set.
PERCENT is optional with TOP.
For example:-
No comments:
Post a Comment