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 6819Post New Covansys Interview Questions
What do you mean by Adjustment
How do I upgrade wordpress?
Is mariadb faster than mysql?
What are different search criteria you can use in quality management system?
How do I protect data validation in excel?
Hi, what do you mean by internal auditing? what are the things they do in internal auditing?what they review? THNX in Advance
Give the principle of potentiometer titration.
how to determine the correctness of proportion used in cement mortor and various IS codes to determine the same?
FAVOURITE PASTTIME BET.PRE-BOARD AND BOARD?
What is assert and when would I use it?
Explain what is meant by polymorphism?
Is objective c type safe language?
What is difference between product and item?
Capture the Unique label changes on google home page for I am feeling lucky button and save those label changes to Notepad Note: Using QTP
What is the most important, or helpful,project that you have contributed to?