Little incentive for vendor to fulfill a normal which would enable customers to change to competitor. New SQL normal might battle with prior behavior of vendor’s database. The solely drawback of Stored Procedure is that it can be executed only in the database and utilizes extra memory in the database server. Apart from this SQL Interview Questions blog, if you would like to get trained from professionals on this know-how, you can opt for a structured coaching from edureka! Having Clause is simply used with the GROUP BY function in a query whereas WHERE Clause is applied to each row before they are part of the GROUP BY perform in a query.
