Question

Students
Id
Name
age
10
Santosh
20
20
Rajesh
25
30
Kiran
30
40
Ramesh
15
50
Priti
18
60
Sachin
20
70
18
80
Sanjay
Rupali
Anjali
0
90
Null
How many rows get updated after executing the below query?
Update students set age=45 where Id=50;
2
1
0
3

Answer 1

Answer:

Bro u need to make a table for this question.

Then I can answer your question. .

thnx. .

Answer 2

Answer:

Update students set age=45 where Id=50;

1 row get updated after executing the  query.

Step-by-step explanation:

Table : Student

Id                        Name             age

10                         Santosh           20

20                        Rajesh              25

30                         Kiran                30

40                        Ramesh            15

50                        Priti                   18

60                        Sachin              20

70                        Sanjay               18

80                        Rupali                0

90                        Anjali                Null

Update students set age=45 where Id=50;

There are 9 rows in the given table.

Only One row has Id=50.

When we will execute the given Update command, Only 1 row with Id = 50 will be updated and new age for that row will be 45

Before Update : 50                        Priti                   18

After Update :    50                        Priti                   45