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/...?
Dumb Fish
-3
Newbie Poster
Recommended Answers
Jump to Postwhat is the table structure and lets see what you have tried so far.
Jump to PostWhat about the SQL that you are working on ?
Show some effort to get any help.
All 7 Replies
debasisdas
580
Posting Genius
Featured Poster
what is the table structure and lets see what you have tried so far.
Dumb Fish
-3
Newbie Poster
table one :
customer table
fields:
code, name, place
sale table
contract quantity, bal, buyers,
debasisdas
580
Posting Genius
Featured Poster
What about the SQL that you are working on ?
Show some effort to get any help.
adam_k
239
Master Poster
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 ?
Netcode
33
Veteran Poster
your need is not clear
Dumb Fish
-3
Newbie Poster
never mind ....i think i solved already..
Netcode
33
Veteran Poster
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.