Java - Interview Questions and Answers for 'Blazeclan' | Search Java Interview Question - javasearch.buggybread.com
Javasearch.buggybread.com
Share

Search Java Interview Questions


 2137 questions in repository.
 There are more than 200 unanswered questions.
Click here and help us by providing the answer.
Label / Company      Label / Company / Text

   



Interview Questions and Answers for 'Blazeclan' - 1 question(s) found - Order By Newest

  Q1. What is a self Join and give an example of a self Join ?Database2016-06-30 20:13:35

Ans. When a Table Join itself , it's a Self Join. For example - we like to know the pair of department names where first dept has lesser employees than the later.

Select D1.name , D2.name from Dept D1, Dept D2 where D1.employee_count < D2.employee_count

 Help us improve. Please let us know the company, where you were asked this question :   

   Like      Discuss      Correct / Improve     sql  joins  self join  self-join  Pair of employee names with first having lesser salary than later  Pair of department names where first dept has lesser employees than the later     Accenture  West Monroe Partners  Oracle  eBay  Impetus Technologies  Bank of America  Fannie Mae  Wize Commerce  Kleward Consulting  Pyramid Consulting  Interra Information Technologies  Trigent Software  Xtreme Media  IGATE  Nagarro  Six Sigma  Nityo Infotech  Fujitsu  BlazeClan  Twist Bioscience  Invoyent  Cognizant (CTS)  i2c      basic        frequent


Related Questions

  What is JDBC? Describe the steps needed to execute a SQL query using JDBC.
 What are Inner , Outer , Left and Right Joins in SQL ?
  Difference between Inner and Outer Join ?
  What is a Cursor ?
  What are temp tables ?
  Does SQL allow null values ? Can we use it within Where clause ?
  Write an SQL to find all records having all upper case alphanumeric characters in a field ?
  Write an SQL to find all records having all numeric characters in a field ?
  Do you know of any DB statement that can be used if we would like to insert multiple rows into a table ?
  What things you will look for if you get following exception while making DB call ?




Subscribe to Java News and Posts. Get latest updates and posts on Java from Buggybread.com
Enter your email address:
Delivered by FeedBurner



comments powered by Disqus
 

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.

Any input from you will be highly appreciated and It will unlock the application for 10 more requests.

Company Name:
Questions Asked:
         

X Close this

1 person from Ashburn are looking for questions for 'Blazeclan'. Connect with them to better prepare for your interview.
X Close this

Help Us Improve.
Please share your
interview experience.

Company Name:   


Questions Asked: