select * from student where rank = a;

how to get rank of diffrent student in same table based on
newly inserted row in sql server2008

Question Posted / raju

Answer Posted / raju

Is This Answer Correct ?

1 Yes

15 No

Please Help Members By Posting Answers For Below Questions

What are the indexes in sql server?

1123

How to find the version of sql server? : sql server database administration

1122

Difference between report and query parameter.

1106

How to sort the query output with order by clauses in ms sql server?

1038

How to provide values to stored procedure parameters in ms sql server?

1047

What is the difference between cartesian product and cross join?

872

Explain the stored procedure?

1057

Give an example of why you would want to denormalize a database

982

What does null mean?

993

Can you explain about buffer cash and log cache in sql server?

957

What is temporary stored procedure?

955

What command is used to create a database in the sql server and how?

1188

How fixed length strings are truncated and padded?

987

What is normalization process?

1182

What is buffer cash and log cache in sql server?

1131