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 8259Post New Covansys MySQL Interview Questions
Explain enable novalidate constraint.
Can I copy a page in word?
What is staffing status.
Is primary key a clustered index?
How do I get a C form with the bank Guarantee?
What additional limitations does sybase replication server present? : hana sql script
What is the maximum row limit in excel 2010?
please send me previous placement papers of cummins company
What is meant by CDOT in relation to the Communication in BSNL? Explain the term CDOT.
What is the difference between windows os and windows server?
Explain what is an interface in c#?
What are the important tasks of common oracle dba?
How to control flow variations in magnetic flow maters..... When i will provide proper earthing?
What is the difference between route and router in ember.js?
Program to print the 32 number in form of binary, Hexa and ASCI.