Hey, I new in MS SQL
I got one question don,t know how to solve..?
Display code, name, place , total contract quantity for top 10 buyers
how to write in MS SQL/...?
what is the table structure and lets see what you have tried so far.
table one :
code, name, place
contract quantity, bal, buyers,
What about the SQL that you are working on ?
Show some effort to get any help.
Not only you are not showing effort, but you are not providing enough to go on. Your 2 tables cannot be joined with the fields that you are providing.
Also how do you define top buyers? By quantity, money, number of contracts ?
your need is not clear
never mind ....i think i solved already..
great, now you're making progress
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.