Any body know these answer

Discussion in 'Databases' started by seopigeon, Dec 13, 2006.

0
  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, Dec 13, 2006 IP
  2. falcondriver

    falcondriver Well-Known Member

    Messages:
    963
    Likes Received:
    47
    Best Answers:
    0
    Trophy Points:
    145
    #2
    i cant give you a syntax if i dont know your tables. however, try something like 
    SELECT (your tables and stuff here...)
ORDER BY salery DESC
LIMIT 0, 2
    Code (markup):
     
    falcondriver, Dec 14, 2006 IP