All of us know about the TOP clause in sql, it returns the top 'n' records from a result set.
But you ever thought about dynamic TOP .
What i mean is,we want to fetch Top 'n' records from a result set where n will be provided as a stored procedure parameter or some other manner.
Query:-
Solution:-
Hope you enjoyed it, will back with some more interesting stuffs.
(please put comments if you like it.)
But you ever thought about dynamic TOP .
What i mean is,we want to fetch Top 'n' records from a result set where n will be provided as a stored procedure parameter or some other manner.
Query:-
Select top @NumberOfRecords From TblFriends --@NumberOfRecords is a sql variableThis query will throw an error ' Incorrect syntax near top'.
Solution:-
Select top (@NumberOfRecords) From TblFriends --here, we can set @NumberOfRecords to any integer value,even to some aggregate function --like, select @NumberOfRecords=min(age) from TblEmployee
Hope you enjoyed it, will back with some more interesting stuffs.
(please put comments if you like it.)
No comments:
Post a Comment
Your comments, Feedbacks and Suggestions are very much valuable to me :)