Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is trigger and different types of Triggers?

0 Answers   QuestPond,

How to tune a stored procedure?

6 Answers  

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,

How to handle errors in Stored Procedures.

2 Answers   Accenture,

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

Explain what are sparse columns?

0 Answers  

What do you think of this implementation? Can this be implemented better?

0 Answers  

Define union, union all, minus, intersect?

0 Answers  

Explain triggers?

0 Answers  

What are policy management terms?

0 Answers  

Explain what is dbcc?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories