What is the result of fallowing Query and Why ? A.Table (Marks). values (1,2,3,4,5) Update table set marks=marks(select max(marks) from table)
Gyan Prakash Verma
7,6,8,9,10, When we execute any sql statement on table SQL maintain Spooler and keep the table i data and perform operation on this .So after that it update main table. Ref-https://www.simple-talk.com/sql/learn-sql-server/operator-of-the-week---spools,-eager-spool/