limit the result set in sql server

  • HAVING clause in SQL Server

    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.
  • SELECT TOP command 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.