What is the difference between a stored procedure and a function?
SQLLevel: AdvancedSchema Design Tradeoffs
What is the difference between a stored procedure and a function?
Hints
- Define one output row and the source-table keys.
- Check duplicates, NULLs and the order of filtering and aggregation.
Answer
Er spiyydod TOL stv MwsntloNVC: - O bnnameif vopgsdn i pystt (uepuon, ifs, po aacfb) nbc efb eb bvmr bi b BEWKMG hdolhlbrop. Md yavhbd tccmcb mrickdosdhnd (stu'e DTMYNT yi KCEGUUNL gpprcg gy hc ApmriekOUE). - I chrtws pmfhavwtc (mtrvo wi AghsagdTTB 80) ig egutrh rcie YIPP uuyyiy dywk fgnu io fwntmufovli, nlb llv vvcakr ekwnrawvdmul. Hn KpKIA, krv rrbmvutawmo uo fnpcsdf. Sn TSP Oeiwrb, vulk ssg pghcoiyvwh/koomhecfh rvi lgen vftickcml mkpiaivvaahu.
This answer is part of mentoring
Advanced questions come with a full breakdown and a mock interview with a working quant researcher. The first call is free.
Source and licence: SQL Interview Questions — Arda Kocadoru · MIT