Need small help in SQL Query

yeahhub

yeahhub

Regular Member
Joined
Jun 5, 2017
Messages
290
Reaction score
41
Please help me to solve one small problem

Below image is a sample data of my Master Data Table

CtpIUGe


And this is what i want to achieve the count of following records as per following screenshots

meqHLS6
 
Advertise on BHW
i can't understand for your description what do you need...a count ?
Example to count all Open status for A1 application

SELECT COUNT(vulnstatus) FROM vulnsummary WHERE vulnstatus = 'OPEN' AND projid = 'A1 Application';
 
I want the count from Vulnsummary table but based on Dataset table, i think some Inner Join function will apply into this
 
Basically i want the count of High Medium and Low values in vulnsummary table.

Got it ?
 
yeahhub said:
I want the count from Vulnsummary table but based on Dataset table, i think some Inner Join function will apply into this
Click to expand...
If you know you need an inner join then this would imply you have an understanding of SQL, I would try more dedicated coding forums first
 
lewo said:
If you know you need an inner join then this would imply you have an understanding of SQL, I would try more dedicated coding forums first
Click to expand...

I know it can only be done with INNER JOIN but i don't know much about this.. still looking for someone who can make a query for me
 
yes then you need to add an inner join statement
 
yeahhub said:
I know it can only be done with INNER JOIN but i don't know much about this.. still looking for someone who can make a query for me
Click to expand...
You’re asking on BHW for a coding related question. You will find the answer a lot quicker on a coding forum.
Failing that learn how to use the inner join command.

Hint: you need to join on vtitleid on datasetid
 
lewo said:
You’re asking on BHW for a coding related question. You will find the answer a lot quicker on a coding forum.
Failing that learn how to use the inner join command.

Hint: you need to join on vtitleid on datasetid
Click to expand...

Yea i thought, there are so many programmers here, let see
i also posted on reddit, and other coding forums, but didn't get any reply yet

These inner join functions are so hard to understand lol
 
I also posted the same on stackoverflow, but their some dumb guys always marked my question as Duplicate..
 
yeahhub said:
I also posted the same on stackoverflow, but their some dumb guys always marked my question as Duplicate..
Click to expand...
This would suggest your question or a similar question has been asked.
Why not invest your time in learning SQL?
 
lewo said:
This would suggest your question or a similar question has been asked.
Why not invest your time in learning SQL?
Click to expand...

Actually this is one small assignment which I've to submit by tomorrow morning and due to WFH, i didn't get much time.

Already engaged with some other things.
 
Because you know that ABC equals low severity, you could quickly use the following Select Count(*) from vulnsummary Where vtitleid = ‘ABC’ to give you all low severity codes for all application id’s
 
yeahhub said:
Actually this is one small assignment which I've to submit by tomorrow morning and due to WFH, i didn't get much time.

Already engaged with some other things.
Click to expand...

maybe you’re studying the wrong course if you can’t work this out, or you’ve done the typical student thing and left it to the last minute to complete
 
Have fun! No one will do your homework. You know that!
Code: 
https://www.w3schools.com/sql/sql_join.asp
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top