Monthly Archives: December 2019

sql top limit

TOP, LIMIT, ROWNUM in SQL: If you want to fetch top N rows from table, you can use TOP clause. This clause is useful when a table contains thousands of records because returning so many records can impact the performance. But all databases may not support TOP clause. SQL Server – TOP MySQL supports LIMIT… Read More »