Outputting the first line in a set of results.

[Siiig]

Currently I have a set of queries that break down to something like this...

Number	Item	Date
0000004	001	9/10/2013
0000004	001	6/14/2013
0000004	001	5/19/2013
0000004	001	2/5/2013
0000004	001	1/19/2013
0000004	001	1/1/2013

What I'd like to do, is take this long query, and only take the first result of the returned values, I.E.:

Number	BillNumber	RequiredDate
0000004	001	9/10/2013

(Note: There are more results in the query, I'm just condensing it).

Something like this ALMOST works...

SELECT DISTINCT dates.Number
FROM dates;

The above will give me a unique list from the "Number" column, but I can't manage to get the data to it's right back into place.

Was hoping you guys could help me out!

[rzw0wr]

Try the TOP function in your query.

Like SELECT TOP 1

Look into this link.

http://www.w3schools.com/sql/default.asp


Dale

[Siiig]

Try the TOP function in your query.

Like SELECT TOP 1

Look into this link.

http://www.w3schools.com/sql/default.asp


Dale

Hey Dale,

Thank's a bunch for the response. Specifically "SELECT TOP 1" gave me a new version of the results, but not quite what I'm looking for. That actually resulted in a full set of results. Let me give you a better example of the data it's pulling...

WorkOrder	BillNumber	RequiredDate
0000007	1	7/4/2013
0000007	1	6/15/2013
0000007	1	5/27/2013
0000007	1	5/27/2013
0000007	1	5/14/2013
0000008	2	6/15/2013
0000008	2	7/4/2013
0000008	2	5/14/2013
0000008	2	5/27/2013
0000009	3	5/14/2013
0000009	3	2/26/2013
0000009	3	6/15/2013
0000009	3	5/27/2013
0000009	3	4/1/2013

Using "Top" will return all the "0000007" records. The only other thing I can think of would be to check the previous records "WorkOrder" table, and then do a looping "not equal to" constraint. Problem being I have no idea how to do that of coarse.

[rzw0wr]

Then you did not use TOP correctly.
TOP number will only return the Top number specified of records.

If you use Top 10, it will return 10 records if 10 are there.

Have you been to the site I gave you?

Dale