Question
How to fetch common records from two tables?
Answers
Common records result set can be achieved by -.

Select studentID from student. INTERSECT Select StudentID from Exam 1
Select studentID from student. INTERSECT Select StudentID from Exam

    Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q Name the fruit of Sematophyllaceae Family ?
  • Q typically supervision is a process of?
  • Q In Salem Oregon its illegal for women to do what
  • Q What is the study of soil called?
  • Q How are routing updates and Point-to-Point Protocol (PPP) / High-Level Data Link Control (HDLC) keepalives processed when a service policy is applied?
  • Q Which built-in method returns the length of the string
  • Q what is the Acronym for HTTP
  • Q How is the nervous tissue distributed in cnidarians?
  • Q What are the important points necessary for construction of a SANITARY WELL?
  • Q Where's javascript?
  • Q What is the slide show view?