tags:

views:

38

answers:

0

Hello excerpts, I have a Database table UserTable

CREATE TABLE [UserTable](
    [ID] [int] NULL,
    [Name] [nvarchar](50) NULL,
    [City] [nvarchar](50) NULL
) ON [PRIMARY]

this table have following data

ID             Name                     City
----------- --------------------------------
1             Vijendra                  Delhi
2             Singh                     Noida
3             Shakya                    New Delhi

Now question there is any way to find out the first column first row without specify the column name(I don't want to use any column name), this is same like to find out the matrix notation, that would be the [1,1]th location.

I can find out the first column first row with

Select Top 1 City from UserTable 

I don't want to user the column name(City).

Is it possible? if yes please tell me how we can achieve this.