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 5349

Post New Covansys MySQL Interview Questions






Un-Answered Questions

WHAT IS DIFFERENT BETWEEN YOU AND OTHER APPLICANT TO GIVE YOU THE JOB

1059


Can an application process documents that use xml namespaces and documents that don’t use xml namespaces?

84


why we should maintain neutral earth voltage below 1V while calibration? why cant it be 1.2V or 2V

1486


Can shell script run on windows?

88


Who discovered ms excel?

3






why you are intrested in junior reasearch fellow

1276


How web services are implemented in .net?

43


How to swap two variables without using 3rd temp variable.

86


What is difference between content store and content manager?

105


How would you choose between a clustered and a non-clustered index?

115


What are the differences between char and varchar?

109


How to protect sensitive loads such as Dosing pumps inside a factory from voltage surge/voltage fluctuation.

732


Mention the use of personalized tab and parameter tab in user master record?

99


When will I be able to use my own tablet as my work computer?

102


Does cp overwrite?

90