SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    Oct 2008
    Posts
    205
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    select 10 student from each department

    I have a big student database, it has only one table. I want to select 10 student each department on a single mysql query.

    +---------------------------------------------------------+----------------------+
    | student | Dept |
    +---------------------------------------------------------+----------------------+
    | gooch | physics |
    | aaaaa | mathss |
    | dvssdg | maths |
    | sfgsfg | chemistry |
    | gcbcvb | chemistry |
    | dgsgsfg | arch |

    I have a big list like this.. I have to select ten student from each department. how shall I achieve it?

    Also I want to select student in random each time.

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,065
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    Is the random student to be selected from all the departments or 1 from each department?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Addict
    Join Date
    Oct 2008
    Posts
    205
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This is not the entire database. I want to select ten students from each department. cosider I have some 20 depatment in my college. I have to select ten student from each department. Hope now you have got it.

  4. #4
    SitePoint Addict
    Join Date
    Oct 2008
    Posts
    205
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    select 5 rows from each department

    I have a big student database, it has only one table. I want to select 10 student each department on a single mysql query.

    +---------------------------------------------------------+----------------------+
    | student | Dept |
    +---------------------------------------------------------+----------------------+
    | gooch | physics |
    | aaaaa | mathss |
    | dvssdg | maths |
    | sfgsfg | chemistry |
    | gcbcvb | chemistry |
    | dgsgsfg | arch |

    I have a big list like this.. I have to select ten student from each department. how shall I achieve it?

    Also I want to select student in random each time.

    This is not the entire database. I want to select ten students from each department. cosider I have some 20 depatment in my college. I have to select ten student from each department. Hope now you have got it.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •