Menu

Showing posts with label descending order query. Show all posts
Showing posts with label descending order query. Show all posts

SQLite query for display result in descending order

descending order query

Write the SQLite query for display result in descending order(Display the age column as a descending order query)


  • 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    | 03 |
  • select * from Friends order by Age desc;
  • output
    | 2 |Kaka    | 22 |
    | 1 |Nitin    | 21 |
    | 3 |Ganesh| 20 |
    | 4 |Sama    | 18 |
    | 5 |Pavan    | 16 |
    | 6 |Akash    | 10 |
    | 7 |Gopi    | 08 |
    | 8 |Rushi    | 04 |
    | 9 |Didi    | 03 |

swamios

For More Information Please Visit

Related Posts Plugin for WordPress, Blogger...