rowid is there?

[vinod]

Hi experts,
I'm in need to use the rowid of a column.
is there any concept like rowid?

for example, i need the first row of a table.or 5th row of a table.how can i write the query?


thank you verymuch in advance.

[ramasp]

Hi experts,
I'm in need to use the rowid of a column.
is there any concept like rowid?

for example, i need the first row of a table.or 5th row of a table.how can i write the query?


thank you verymuch in advance.

select top 1 * from tablename

[ramasp]

Add a column of int datatype to the existing table. Define identity on that column. Define Identity seed and identity increment as 1,1.
The following is the syntax.

a int identity(1,1). Here a is the column. SQL Server automatically increments the number. Based on that number you can fetch the desired record.

[vinod]

Using Identity function is really great friend.
I'm trying for my purpose now, if i need some more assistance, i'l come back to you

[Nyiti]

Hi there!

Try this:
select CityID,
c.CityName,
ROW_NUMBER() OVER(ORDER BY c.CityName, c.CityID desc) AS RowID
from City AS c

So you can manage the multiple columns ordering too.

Bye!
Nyiti

Hi experts,
I'm in need to use the rowid of a column.
is there any concept like rowid?

for example, i need the first row of a table.or 5th row of a table.how can i write the query?


thank you verymuch in advance.

[debasisdas]

rowid purely is a concept of oracle.