Showing entries 1 to 1
Displaying posts with tag: set oriented (reset)
Simulating procedural logic

Sometimes I see people having great difficulties in describing how to fetch data for a report.They are unable to reason by sets and tend to describe things in procedural terms.Here I'm posting a small example of how you can write a query that reproduces that procedural reasoning and lets the optimizer do the work of translating it into efficient SQL.Say someone has a table structure like this, a

Showing entries 1 to 1