Computer Science, asked by sh8940231, 10 months ago

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

Answered by mariospartan
2

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

Similar questions