limiting returns


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: limiting returns

  1. #1
    Tom H Guest

    limiting returns


    I have patients with their lab result. Some have 1-5 labs. I want to write
    a sql that will only return 1 or 2 og theirs most recent labs. help.....

  2. #2
    David Satz Guest

    Re: limiting returns

    this will work in TSQL/MS SQL 7+:
    SELECT TOP 1 *
    FROM labs
    WHERE patient_id = @ThePatientId
    ORDER BY visit_date DESC
    --
    HTH,
    David Satz
    Principal Web Engineer
    Hyperion Solutions
    { SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
    (Please reply to group only - emails answered rarely)
    -----------------------------------------------------------------
    "Tom H" <divebudsc@mindspring.com> wrote in message
    news:3c6abfcb$1@10.1.10.29...
    >
    > I have patients with their lab result. Some have 1-5 labs. I want to write
    > a sql that will only return 1 or 2 og theirs most recent labs. help.....




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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center