SQL Interview Question for selecting TOP 5 customers from order database
Select cid ,sum(ordertotal) as totval from order
GROUP BY cid
ORDERBY totval DESC
LIMIT 5
Watch video SQL Interview Question for selecting TOP 5 customers from order database online without registration, duration hours minute second in high quality. This video was added by user Learnwithss 27 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5 once and liked it people.