how can i select max row which in the sqlserver table
?nd how can i move between table rows
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
ahmed fahdPosted Jan 7, 2013, 12:36 PM
but i want to get the max row in the table rows index
,the max row not max columns values
i tried to use limit key word and give it row number but it wasn't suitable in visual studio sql
i tried to use rownum keyword but also it wasn't suitable
i want to deal with the index of the rows to move between rows
Jignesh TrivediPosted Jan 6, 2013, 10:52 PM
I can not get your quesion end to end.
but up to i understand from your quesion is you want to find max row from SQL table and also move data between rows? correct?
so you can use MAX key word to find max row from table.
select Max(salary) from EmpMaster.
and you can move row data by using update statement.
hope this will help you.