Hi please help me

Discussion in 'Programming' started by seopigeon, Nov 13, 2006.

  1. #1
    Hi all,

    I dont know much about programing i have some questions about DBMS. please help me.

    Using aggregate functions solve these questions

    The questions is 1. Find the first and second largest salary of the employee ?
    2.Display the odd number record ?
    3.Display the even number record?

    give me the syntax.


    Thanks,
    seopigeon
     
    seopigeon, Nov 13, 2006 IP
  2. Nick_Mayhem

    Nick_Mayhem Notable Member

    Messages:
    3,486
    Likes Received:
    338
    Best Answers:
    0
    Trophy Points:
    290
    #2
    You want query for this thing?

    If yes then give the example table name and feilds name and I can post the query right here.
     
    Nick_Mayhem, Nov 13, 2006 IP
  3. seopigeon

    seopigeon Banned

    Messages:
    249
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    ok you give query for this thing are else u give the syntax.
     
    seopigeon, Nov 13, 2006 IP
  4. Nick_Mayhem

    Nick_Mayhem Notable Member

    Messages:
    3,486
    Likes Received:
    338
    Best Answers:
    0
    Trophy Points:
    290
    #4
    Query can only be given if I know the data format friend.

    I need to know the exact structure of the tables and the data in it.
     
    Nick_Mayhem, Nov 13, 2006 IP
  5. seopigeon

    seopigeon Banned

    Messages:
    249
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    These questions we have to solve using aggregate functions only.I dont know the structure of the tables.
     
    seopigeon, Nov 13, 2006 IP
  6. seopigeon

    seopigeon Banned

    Messages:
    249
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Hi,

    Any body know these answer please let me know.
     
    seopigeon, Nov 15, 2006 IP