oracle - Total count in sql -


i need create view display total number of students have declared 2 majors (major1 , major2 not null).

what query should use?

my goal single row of output know order by clause irrelevant in case.

something this: 

    create view getnumberofstudentswithmajor           select count(*) dbo.students major1 not null , major2 not null

-

Comments

Post a Comment

Popular posts from this blog

java - Solr query version issue: Invalid version or the data in not in 'javabin' format -

as part of recent project, our solr search engine upgraded 5.0.0. program runs client works fine in production/qa, when run on local system, error message: caused by: java.lang.runtimeexception: invalid version or data in not in 'javabin' format @ org.apache.solr.common.util.javabincodec.unmarshal(javabincodec.java:99) this exception apache-solr-solrj-1.4.1.jar, would've thought needs replaced. when check (running) production code, same jar file there. however, java version on production server has been upgraded java version "1.7.0_79". on local system, i'm pointing @ 1.6 jre sts/eclipse. if change 1.7, start getting 51 vs. 50 class version error in different part of program, indicating there's issue converting 1.7, although again doesn't seem problem on production server. i have tested solr server running correctly via web client. returns data in json format. one question have is, mean when says "invalid version or data isn'...
Read more

Hard vs. Soft Water: What's The Difference?

Hard or Soft? HOW AM I SUPPOSED TO KNOW? THEY BOTH LOOK EXACTLY THE SAME! Hey there, Sapna here for Dnews. From the outside, all water is seemingly the same: clear, mostly flavorless, two hydrogens, one oxygen. But once you get past the basics, water is actually pretty versatile. It can be distilled, filtered, tap, bottled, and if you're real fancy, there's water marketed as kosher, organic or kabbalah. But did you know water can also be hard or soft? No, this isn't to describe how the water actually feels. It actually has to do with its mineral content. Water becomes ‘hard' when it has a higher than normal concentration of minerals, primarily calcium and magnesium. Water picks up these minerals from rocks and soil as it flows through rivers, wells or other waterways. Soft water, on the other hand, has a low mineral content, either because it has not yet flowed through rocks or wells - like rain water - or because the rocks it has come in contact with have little to no...
Read more

Weed, Guns & Minimum Wage: What Else Is The U.S. Voting On?

We've heard a lot about the presidential candidates in this election, but few people are talking about arguably the second most important vote many will be making on election day. State propositions, which voters can use to change state law directly. Certain important issues have cropped up in multiple states, and may even end up changing federal law. So we wanted to know, what are the most controversial 2016 ballot trends? One of the most attention-getting issues this year is recreational marijuana, the US's most popular illicit drug. Five states have ballot initiatives that could legalize the drug. If passed, California, Nevada, Arizona, Massachusetts and Maine will join the weed-legal Colorado, Oregon, Washington, Alaska and the District of Columbia. The major player in this scenario is California. The state has the sixth largest economy in the world with a GDP of nearly $2.5 trillion dollars and it commands 55 seats in Congress. Should marijuana be completely legalized, it...
Read more