×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Yep:
Select *
From ...
Where ...
Fetch First Row only;
To select more than a single row modify Fetch First Row Only to Fetch First
x Rows (where x is the number of rows)
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Darryl Freinkel
Gesendet: Friday, 07. January 2011 18:37
An: midrange-l@xxxxxxxxxxxx
Betreff: How to limit rows read to 1 rows
I have a SELECT statement that returns more than 1 record for a invoice. The
file can have 1 to many invoice records with the same invoice number.
I need a way to limit the select, to read only one of those invoice records.
There is a solution using LIMIT, but I cannot get that to work.
Example:
Select * from table1 T1 where T1.INVOICE in
(Select T2.Invoice from table2 T2 where T1.Invoice = T2.invoice LIMIT 1)
TIA
Darryl Freinkel
midrange.com
