www.webdeveloper.com
Results 1 to 2 of 2

Thread: sql querry problem

  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Angry sql querry problem

    Hi
    Hai friends ..
    Can any one help me to find out the highest salary,second hights salary,and top 5 salary, and least 5 salary from a data base in sql server/oracle.

    thank

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    sure

    SELECT highest_salary, second_hights_salary, top_5_salary, least_5_salary FROM your_table;

    but for some reason, i doubt that's how your table is structured so why don't you tell us how its structured!
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles