User Profile

Collapse

Profile Sidebar

Collapse
pushaskhelp
pushaskhelp
Last Activity: Jun 24 '10, 09:03 AM
Joined: Jun 22 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pushaskhelp
    replied to latest date problem
    in Oracle
    I will explain with example:

    suppose there is
    ID submission_date (yy.mm.dd)
    1 2009-07-06
    2 2009-03-07
    3 2009-06-06
    4 2010-06-06
    5 2009-07-06

    now if I say SELECT submission_date latest to '2009-06-06' then I want only ID 1 and 5 which is latest(close) to given date( bcz ID 1 and 5 have same submission_date )
    ...
    See more | Go to post

      Leave a comment:

    • pushaskhelp
      started a topic latest date problem
      in Oracle

      latest date problem

      have one table with columns: ID and submission_date
      now I have to select ID from this table where submission_date is latest to given date.
      See more | Go to post
      • pushaskhelp
        started a topic Null date
        in SQL Server

        Null date

        I have one table with id,name,submiss ion date and followup date.
        followup date may be null.
        i have to select id from this table where followupdate is less than given date.
        and if followup date is null then I have to select id from this table where submission date is less than given date.
        See more | Go to post
        No activity results to display
        Show More
        Working...