How to select earliest record?

Dev Shed Forums Sponsor:

March 17th, 2012, 12:30 PM

Biznez

Registered User

Join Date: Feb 2012

Posts: 7

Time spent in forums: 3 h 25 m 29 sec
Reputation Power: 0

How to select earliest record?

hello everyone, im trying to get the earliest record. data is below

note_id/ doc_received_date/ bankruptcy_date/ sp_recorded_date
2332/ 20090106<----/ 20081219/ 20090106
2332/ 20090323/ 20081219/ 20090323
2332/ 20090413/ 20081219/ 20090413
2332/ 20090507/ 20081219/ 20090507

because the bankruptcy_date date are all equal i would need to pull one record with the earliest date from the doc_received_date. The date with the arrow is the record i want. So basically i would like to show this result

note_id/ doc_received_date/ bankruptcy_date/ sp_recorded_date
2332 20090106 20081219 20090106

Hope this made sense.. Thanks for you ur help

March 17th, 2012, 02:20 PM

LetThereBeByte

Registered User

Join Date: Mar 2012

Posts: 2

Time spent in forums: 33 m 29 sec
Reputation Power: 0

Quote:

Originally Posted by Biznez

Hello,

how about something like SELECT TOP 1 * FROM [tableName] ORDER BY doc_received_date DESC

March 18th, 2012, 06:43 AM

r937

SQL Consultant

Join Date: Feb 2003

Location: Toronto Canada

Posts: 26,355

Time spent in forums: 3 Months 1 Week 2 Days 4 h 25 m 19 sec
Reputation Power: 4140

Quote:

Originally Posted by LetThereBeByte

how about something like SELECT TOP 1 * FROM [tableName] ORDER BY doc_received_date DESC

yes, if "something like" is this --

Code:

SELECT TOP 1 *
  FROM daTable
ORDER
    BY bankruptcy_date
     , doc_received_date

note that DESC is not correct in this probelm

there's also this approach --

Code:

SELECT *
  FROM daTable
 WHERE doc_received_date =
       ( SELECT MIN(doc_received_date)
           FROM daTable
          WHERE bankruptcy_date =
                ( SELECT MIN(bankruptcy_date)
                    FROM daTable ) )

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book

Viewing: Dev Shed Forums > Databases > MS SQL Development > How to select earliest record?

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump