How the number of rows in the current data access database in c #-CodePudding

How to obtain the current database of the data line number, is not a line number

CodePudding user response:

Line number is what the devil, general is id, can be self growth can also be a guid

CodePudding user response:

Hope the rownumber can help you

CodePudding user response:

refer to the second floor YBcsdn1996 response:

hope to help you rownumber

How do you use the Rownumber? Can you give code?

CodePudding user response:

The concept of database, there is no line number
What do you want to do, please just say

CodePudding user response:

The mysql example
SELECT @ num:=@ num + 1 as num, 'as AA1,' as AA2 FROM
(select 0 union all select 1 union all select 2) t1,
(select 0 union all select 1 union all select 2) t2,
(select 0 union all select 1 union all select 2) t3,
(select 0 union all select 1 union all select 2) t4,
(select 0 union all select 1) t5,
R: (SELECT @ num=0)

CodePudding user response:

NJHouse_JFSJ is your table, so check each with a line number
SELECT @ num:=@ num + 1 as num, b.j FSJ FROM (SELECT @ num:=0). A, b NJHouse_JFSJ

If it is oracle, is to use rownum ()

CodePudding user response:

The
?

CodePudding user response:

,, database and line number said this?????

That I'll find a press line number delete, among others deleted at the same time a number of the row number, do you have what use,

CodePudding user response:

Essentially a sample

Select *, ROW_NUMBER () OVER (ORDER BY UserID asc) as' serial number from the UserInfo

CodePudding user response:

refer to the eighth floor hui1202 response: ,

, database and line number said this???????

That I'll find a press line number delete, among others deleted at the same time a number of the row number, do you have what use,

there must be, also can call number, generally in performance ranking ranking places need to know

CodePudding user response:

reference gezhu1212 reply: 3/f

Quote: refer to the second floor YBcsdn1996 response:
hope to help you rownumber

How do you use the Rownumber? Can you give code?

9 floor has been posted