query last value

Question

Currently I've this query:

SELECT l.klantId,
       bh.rechten,
       kg.voornaam,
       kg.achternaam,
       kg.woonplaats,
       kg.telefoonnr,
       og.klantbericht,
       s.klantstatus
FROM   login l
       INNER JOIN klantGegevens kg
               ON l.klantId = kg.klantid
       INNER JOIN bevoegdheden bh
               ON l.rechten = bh.id
       INNER JOIN orderGegevens og
               ON og.loginNr = l.klantid
       INNER JOIN status s
               ON s.id = og.klantstatus
WHERE  l.klantid = 1

enter image description here

I only want to receive the last ordernr from a klantid. What's the right way to do this. I've already tried this with "last()" but that doesn't work.

Thankss

@Fireblade The screenshot is from SQL Server Management Studio, so I think it's ok to assume that it's SQL Server — Lamak, May 27 '15 at 20:37

score 3 · Accepted Answer · answered May 27 '15 at 20:33

3

select top 1 
       l.klantId, bh.rechten, kg.voornaam, kg.achternaam, kg.woonplaats, kg.telefoonnr, og.klantbericht, s.klantstatus 
from login l 
inner join klantGegevens kg on l.klantId=kg.klantid 
inner join bevoegdheden bh on l.rechten=bh.id 
inner join orderGegevens og on og.loginNr=l.klantid 
inner join status s on s.id=og.klantstatus 
where l.klantid=1 
order by ordernr desc

answered May 27 '15 at 20:33

juergen d

201,996
37
293
362

I wonder, how a lot? I use "sql server select last record" and find this on TOP 1:http://stackoverflow.com/questions/177323/how-to-read-the-last-row-with-sql-server – tjeloep May 28 '15 at 00:47

score 0 · Answer 2 · answered May 27 '15 at 20:36

0

T-SQL: use TOP 1

PL/SQL: use ROWNUM <= 1

MySQL: use LIMIT 1

answered May 27 '15 at 20:36

Riad Baghbanli

3,105
1
12
20

query last value

2 Answers2