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

Answer Posted / raju

select * from student where rank = a;

Is This Answer Correct ?    1 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of subquery?

726


How to add code to the existing article (using improve article)?

602


What is an identity?

574


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

679


Tell me in brief how sql server enhances scalability of the database system?

540






How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1305


What are page splits?

588


Working with TLogs

1458


What is in place upgrade in sql server?

526


What are audit control procedures?

593


What is nested transaction?

538


How do I view a procedure in sql server?

547


last function used in MS Access to convert sql what function will use in sql

1612


How use inner join in sql server?

621


Can group functions be used in the order by clause in ms sql server?

599