Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Covansys MySQL Interview Questions
Questions Answers Views Company eMail

SQL: 1. Write a queryto retrieve the author who was published a book at the youngest age? 2. write a query to retrieve the no. of books published a each year in various languages? 3. write a query to retrieve no. of books published by them only those authors who have published more than 1 book? 4. write a query to retrieve who has not published any books during the year 2006? 5. write a query to retrieve the authors who has published any books during the birth date write this query in 2 ways 1)joins 2)sub query 6. write a query to retrieve all the books which was published during jan 2007 & title containing India or published in the language hindi? 1. table name is liberary managemnt and two column is there one is authors and another one is books . 2.four fields will comes under authours like nationality, birthdate ,first-language,second-language 3.four fields will comes under books like authour,title ,language,publish date to write query using this details

4 5414

Post New Covansys MySQL Interview Questions






Un-Answered Questions

What is the prefix of WordPress tables by default?

40


Why convert an applet to an application?

164


Calculate the missing figures for company A. A Sales (TSR) (a) Total Variable Costs (TVC) (b) Total Fixed Costs (TFC) $24,000.00 Profit $0.00 Units Sold 1,000.00 Contribution Margin Per Unit (CMU) (c) Contribution Margin Ratio (CMR) (d) Break-Even Point (BEP) (Units) (e) Break-Even Point (BEP) (Dollars) $60,000.00

1235


What is the process chain and how you used it?

110


Can I use node js with php?

97






What is rpa technology?

1


How to recovery from deadlock?

141


What does sqldatareader return?

87


How does an execution block start and end in pl sql?

88


What is a metadata in .net?

128


why is the power generator connected as star earthed or star earthed through reactance and what its features ?

678


How can you check in sap system, how, when and by whom which fields in the customer master record were changed?

149


What are scripts in psychology?

105


How to integrate appache with weblogic?

122


How do I make an exe file installed?

88