Member Avatar for Dumb Fish

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/...?

  • 4 Contributors
  • 7 Replies
  • 106 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by Netcode
Member Avatar for debasisdas

what is the table structure and lets see what you have tried so far.

Member Avatar for Dumb Fish

table one :
customer table
fields:
code, name, place

sale table
contract quantity, bal, buyers,

Member Avatar for debasisdas

What about the SQL that you are working on ?

Show some effort to get any help.

Member Avatar for adam_k

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 ?

Member Avatar for Netcode

your need is not clear

Member Avatar for Dumb Fish

never mind ....i think i solved already..

Member Avatar for Netcode

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.