Buy Questpond's video subscriptions on
huge discount
.
Online: 2442
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Codes
>
Loading ...
Set Top N Rows in SQL Serevr Select Query other than TOP
Posted by
Lakhangarg
under
Sql Server
category on
4/29/2010
| Views : 4517
Post Code
|
Search Codes
|
Code Home
One Method to Select Top N rows is :
Suppose N=5
SELECT TOP 5 * FROM Table1
and the second method to do the same is:
SET ROWCOUNT 5;
SELECT * FROM Table1;
Thanks
Lakhan Pal Garg
Alert Moderator
Bookmark It
Comments or Responses
Login to post response
Latest Code Snipptes
Uber Clone - Taxi Booking App
writing Custom pagination html code in python and django
Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
More ...