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 6835Post New Covansys Interview Questions
Does c++ have finally?
How do I fix regsvr32 exe error?
You are a project manager working on contract. You’ve performed earned value analysis and discovered that the project will be completed on time and under the original estimated amount. This means the profit to your company will decrease as will your personal bonus. Which of the following should you do? A. Add activities to the project to increase the cost enough to meet the original estimated amount. B. Tell the customer you're adding additional requirements to the project chat were originally cut because of cost constraints. C. Inform the customer that the project is completed and has come in under budget. D. Bill the customer for the full amount of the contract as this was the original agreed-upon price.
How can I call a 'hidden' DOS program from VB?
What is title in html?
How do you avoid deadlock while coding?
what happen when power factor of 2 parallely operated transformer become equle?
What is the difference between realloc() and free() in C++?
what does dfu program you to do on a record?
Does rna molecule have two polynucleotide chains likewise dna?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Explain the differences between siebel 7.8 and 8.0?
how do I activate a network interface?
Can you explain the key principles of aerodynamics and how they are essential in aircraft design?
How is diagnosis done in ayurveda?