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 :
customer table
fields:
code, name, place

sale table
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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.