How can I get row number of any column in our database ?

Question

1.00/5 (3 votes)

See more:

Actually I want to access a particular Field and I want to get ROW number of a particular Column in our database
Please give me the Answer

What I have tried:

Select ROW_Number() Over(Name) from Student

Posted 28-Sep-17 1:27am

Satyanand Bhardwaj

Updated 28-Sep-17 19:30pm

v2

Add a Solution

Comments

Satyanand Bhardwaj 28-Sep-17 8:22am

Actually sir i want get Index number of a column like-
Select Indexnumber(Name) from Student

i want to get index number of Name...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Accepted Answer · 2017-09-28T01:43:00

I do not think you can directly do that in any valid SQL query and actually get a valid response — because column-indexes can easily change due to the way that a table is defined — without applying a hack around it. Also, it doesn't make any sense, why not the column_name?

For the SELECT statement, you need to either pass the column names or the wildcard. Once the data has been returned, you can read the column by index. That can be done through any SQL reader, such as C# objects for the SQL Server or other similar for MySQL.

But before that, I don't think that is possible. Only a few of the areas permit you to use an ordinal value or the column; ORDER BY clause etc.

There is a similar question on CodeProject you might want to try that, [Solved] SELECT columns by column-index NOT by columnname![^]

Satyanand Bhardwaj · Accepted Answer · 2017-09-28T19:30:00

Solution 2

SELECT      C.ORDINAL_POSITION
FROM        INFORMATION_SCHEMA.COLUMNS AS C
WHERE       C.TABLE_NAME = 'TableName'
        AND C.COLUMN_NAME = 'Password'

Posted 28-Sep-17 19:30pm