Write the SQlite query for find the age between 10 to 20 and show list of that name whose age between 10 to 20.
- Database Name: MyCircle, Table Name: Friends
|ID|Name |Age|
| 1 |Nitin | 21 |
| 2 |Kaka | 22 |
| 3 |Ganesh| 20 |
| 4 |Sama | 18 |
| 5 |Pavan | 16 |
| 6 |Akash | 10 |
| 7 |Gopi | 08 |
| 8 |Rushi | 04 |
| 9 |Didi | 04 | - select * from Friends where Age between 10 and 20;
- output
| 3 |Ganesh| 20 |
| 4 |Sama | 18 |
| 5 |Pavan | 16 |
| 6 |Akash | 10 |
For More Information Please Visit
No comments:
Post a Comment