Select first row only

[jamesd0142]

Hi i want to select the first row only in my table... i have this:

[code=sql]
declare @abc varchar(2000)
set @abc = (select Sql_Table_Name from temptable10)
print @abc
[/code]

how can i edit it to only retrieve the value from the first row only?

Thanks

[azimmer]

Hi i want to select the first row only in my table... i have this:

[code=sql]
declare @abc varchar(2000)
set @abc = (select Sql_Table_Name from temptable10)
print @abc
[/code]

how can i edit it to only retrieve the value from the first row only?

Thanks

Use the TOP keyword:

declare @abc varchar(2000)
set @abc = (select [B]TOP 1[/B] Sql_Table_Name from temptable10)
print @abc