hi, how can i filter sub query just for first item on sorted list? for example lets assume i have employee list with employment date . i want to sort employ by employment date and select first item in list (like "select top1 from .." is sql ).
i know that i can use MAX aggregate in sub query to reach the goal but first approach is more efficient and need less condition in subquery.
