we store and display scores of users in different games. In MySQL, records are stored as tuples (user-id, game-id, score). Now we need to support ranks of users, i.e., each user should be informed of his current rank in the community. The challenge is to come up with the best way to store the data in MySQL so that the requirements are efficiently met.
1 3493please send me the current affairs and general knowledge questions and answers of last 6 months.
37 49496Post New IndiaTimes Interview Questions
How to Re-execute export From Table ?
When users are navigating through the Amazon website, they are performing several actions. What is the best way to model if their next action would be a purchase?
Which sql most popular?
Explain key features of Spark
what are the adjustments and treatment with connection to the profit and loss appropriation accounts and how they do?
How do you name a column in excel?
What is variant in reporting?
Explain different types of collation sensitivity?
How many InputSplits will be made by hadoop framework?
What is the function of cognos dispatcher?
How does the security of a block works?
What is the full form of os?
Explain about the execution plans of a Pig Script? Or Differentiate between the logical and physical plan of an Apache Pig script?
What is save point in mysql?
how to get @@error and @@rowcount at the same time? : Sql dba