Mini-Project MySQL Hands-on solution | TCS Fresco Play
Disclaimer: The primary purpose of providing this solution is to assist and support anyone who are unable to complete these courses due to a technical issue or a lack of expertise. This website's information or data are solely for the purpose of knowledge and education.
Make an effort to understand these solutions and apply them to your Hands-On difficulties. (It is not advisable that copy and paste these solutions).
All Question of the MCQs Present Below for Ease Use Ctrl + F with the question name to find the Question. All the Best!
If you found answer for any of the questions is wrong. Please do mention in the comment section, could be useful for others. Thanks!
_________________________
1. Scoring System
select id,name from student
order by score desc,id asc
limit 3;
2. Student Rank
select score from
(select * from student
order by score desc
limit 213) as a
order by a.score
limit 1;
Post a Comment