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.