Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / diveyandu

Answers were Sorted based on User's Feedback



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

Answer / diveyandu

use dense_rank over(partition by stu_exam_date order by
stu_id) as stu_rank show a particular date student exam or
diff activity rank

Is This Answer Correct ?    4 Yes 2 No

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

Answer / naveen

place identity on a column at the time of creating table

Ex:
create table test(studentrank identity(1,1))

Is This Answer Correct ?    0 Yes 3 No

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

Answer / abi

select rank from student;

(because we dont know if the rank field is inserted r not)

Is This Answer Correct ?    0 Yes 4 No

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

Answer / raju

select * from student where rank = a;

Is This Answer Correct ?    1 Yes 15 No

Post New Answer

More SQL Server Interview Questions

Explain DBCC?

0 Answers   QuestPond,

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

What are different types of statements that are supported by sql?

0 Answers  

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

0 Answers  

Explain how dts is used to extract, transform and consolidate data?

0 Answers  

What is the difference between a function and a trigger?

0 Answers  

What is the server name in sql server?

0 Answers  

can we have a nested transaction? : Sql server database administration

0 Answers  

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

For more SQL Server Interview Questions Click Here
Categories