Results 1 to 3 of 3

Thread: about sql

  1. 08-30-2008, 08:16 AM #1
    tvareddys.reddy
    tvareddys.reddy is offline Member
    Join Date
    Aug 2008
    Posts
    3
    Rep Power
    0

    Default about sql

    please help me
    how to find second maximum salary and third maximum salary
    please send me sql command for that
    Reply With Quote Reply With Quote
  2. 08-30-2008, 06:36 PM #2
    masijade
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,366
    Rep Power
    7

    Default

    Find an SQL forum
    Reply With Quote Reply With Quote
  3. 09-05-2008, 05:48 AM #3
    MuthuKumar
    MuthuKumar is offline Member
    Join Date
    Aug 2008
    Posts
    5
    Rep Power
    0

    Default

    For example Employee is the table, then
    Select Max(Salary)
    From Employee
    Where Salary < (Select Max(Salary) From Employee)
    This sql query is to find the second maximum salary
    Reply With Quote Reply With Quote
« Convert the application from 9i to 10g | Power of Java »

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
  •  

Forum Rules