Three basic rules only. Where you can place sub query?3 places where you can place your sub query:SELECT —– FROMFROM —– WHEREWHERE —–> SELECT —– FROM_____________________(sub query can only return single value & no alias to value returned is required) Correct:_________ (select max(val) from abc where —) Ex output: 10(select top 1 val from […]
