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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-13 : 09:45:17
|
| sachin writes "Hi, Can you please tell me how do i select 5th or possible any row\record i want using a singel sql query. Regarding the table it doesnt have any unique/primary key nor does it have any identity column/field. As you have rowid in sql but what about Ms-sql. Thanks in advance" |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2001-12-13 : 09:53:08
|
| There is no guarentee that rows will be sorted and stored in a particular order in SQL. If you have a rowid, you can use that. Other then that, you need some other way to identify the record you're trying to pull. |
 |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2001-12-13 : 13:29:20
|
| The article "Whats after top" will get you what you need. [url]http://www.sqlteam.com/item.asp?ItemID=566[/url]To the best of my knowledge there is no internal row id in sql (I'm assuming you meant ANSI-SQL); there is such a thing in Oracle and maybe the implementations of other sql vendors. hth,Justin |
|
|
|
|
|
|
Sql Select Query But not simple one