Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ssmani84
Starting Member
20 Posts |
 Posted - 2010-03-13 : 06:44:46
|
| any of the method equvalent to mysql limit or oracle Rownum in sqlserverssmaniyadav |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-03-13 : 08:43:00
|
row_number()
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-13 : 14:20:48
|
| i think equivalent of limit is top in sql server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-13 : 18:23:37
|
quote:
Originally posted by visakh16
i think equivalent of limit is top in sql server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
You are correct  |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-03-13 : 23:22:45
|
LIMIT in MySQL does not exactly equate to TOP () in SQL Server.quote:
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
It supports offset, row_count etc which can be handle by using row_count() row_number()
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-14 : 00:28:25
|
quote:
Originally posted by khtan
LIMIT in MySQL does not exactly equate to TOP () in SQL Server.quote:
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
It supports offset, row_count etc which can be handle by using row_count()
KH[spoiler]Time is always against us[/spoiler]
did you mean row_number()------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-03-14 : 00:32:53
|
quote:
Originally posted by visakh16
quote:
Originally posted by khtan
LIMIT in MySQL does not exactly equate to TOP () in SQL Server.quote:
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
It supports offset, row_count etc which can be handle by using row_count()
KH[spoiler]Time is always against us[/spoiler]
did you mean row_number()------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
yes 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
My sql Limit and Oracle RowNum Equvalent To Sql?