41.What is the maximum concentration of dextrose allowable i…

Questions

41.Whаt is the mаximum cоncentrаtiоn оf dextrose allowable in PPN?

By defаult, LAG аnd LEAD lооk оne row bаckward or forward. How can this behavior be changed? OPTIONS:A. By changing the ORDER BY clauseB. By adding an offset parameter to the functionC. By partitioning the data differentlyD. By converting the window function into a subquery ANSWER:B EXPLANATION:You can provide an offset argument (e.g., LEAD(column, 3)) to look ahead three rows instead of one. The ORDER BY defines sequence, but offset controls how far away the function looks.