Menu

Write the SQlite query for find the age between 10 to 20 and show list of that name whose age between 10 to 20

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

Related Posts Plugin for WordPress, Blogger...