Understanding where-clause in a while-select Statement

(0) Share

Report

Posted on by Community Member

Hi Community,

I am trying to understand this select Statement, especially the last line.

    while select VehicleId, StartDate, EndDate
        from rentTable
            where rentTable.VehicleID == this.VehicleID 
                && rentTable.RecId != this.RecId

with the last line, do You there clarify that this new Records RecId is not equal with one RecId of the rentTable ?

I basically say "Choose for me from the rentTable, those VehicleIds which are the same as the one I have entered"

and with the second where clauseI clarify also that None of the records RecIds selected, are the same as my new records recId ?

This is I guess also a good way to separte selected records from the new record created, right ?

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

In 2nd part of where clause it is saying

"search from all records except current record" OR "Search from all records except me"

The first part says what you have mentioned above "Only those records where VehicleId is same as current value of vehicle id"

combine it becomes as

"Select VehiceID, startDate and EndDate from all records where VehicleId is same as current value, excluding current record in search results"

Was this reply helpful? Yes No