HAVING clause in SQL Server
the having clause is used in conjunction with the group by clause in sql server (transact-sql) to limit the group of returned rows, only when the condition is met is true.
Tags : limit the result set in sql server
SELECT TOP command in SQL Server
in sql server, the select top command is used to retrieve records from one or more tables in sql server and limit the number of return records based on a fixed value or percentage.