#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2014
    Posts
    1
    Rep Power
    0

    Help about qyery


    want to make a query that display them with the following figure

    dept_name xxx dept_id = 10
    -------------------------------
    emp_id emp_name salary
    1 bb 100
    2 nn 200
    sum 300

    * mean display each department alone , with it's emp. and their id& sal
    then the sum of their sal. at the end of sal. column
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    859
    Rep Power
    388

    Cool


    Interesting Homework, what have you done so far?

IMN logo majestic logo threadwatch logo seochat tools logo