retrieve of data in sqlm server 2008

Posted by Shanky11 under Others on 8/24/2012 | Points: 10 | Views : 868 | Status : [Member] | Replies : 2
how to get data of 6ooth row in from a table column name is unknown




Responses

Posted by: Nkkppp on: 8/24/2012 [Member] Starter | Points: 25

Up
0
Down
Select top 1 <Column_Name> from (select top 600 <Column_name>from <table_name> order by <Column_name> desc) <Temp_table Name>

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Shanky11 on: 8/25/2012 [Member] Starter | Points: 25

Up
0
Down
column ka nam nhe pta ho to

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response