Jagriti wrote the following query but it did not give the desired result SELECT MemberName,Amount FROM CLUB WHERE GAME =NULL OR GAME ='Table Tennis';
Answers
Explanation:
The expectation is not given in the question. I am assuming the expectation and based on that I am answering the question.
1. Whenever "null" operator is used, we can use "IS null".
Example:
Select Membername, amount
from club
where Game is null or Game = 'Table Tennis'.
2. Whenever we search for text or string, we can use 'like' operator instead of '=' operator
Example
Select Membername, amount
from club
where Game is null or game like 'Table Tennis'
You can also use wild card characters in the like operator depending on the requirement.
3. Based on the expectation change the where clause accordingly.
To Know more:
https://brainly.in/question/8486848
Plz give me a all sql queries and commads questions bcoz tommorow is my board exam of computer class 10
https://brainly.in/question/7751884
How to write SQL Queries