Write a query to display the details of the students who have scored 90 Marks in at least one subject

Answer 1

How should I answer this question? you did not even describe the tables used, what fields they contain, how the students table relationship with the subjects and scores tables. I don't suppose you expected a wild guessing answer did you?

Answer 2

SELECT DISTINCT * FROM `students` WHERE `score`='90'