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 8069Post New Covansys Interview Questions
Dear Sir, I am working in account department. I want to know, Why service tax rate is change in every type of service. For Example - Rent Bill Service Tax Rate - 10.30% Taxi Bill - Service Tax Rate - 4.12% Why it change
How to Use an animated cursor?
Are you able to work with multiple phone lines?
What is pip and pip freeze commands will do?
any input on how to spec out(if possible) a larger grain structure(3/8" or larger) on a Al 6061 forging material.
Explain notifyall() method of object class ?
Explain opportunity cost and differential cost.
How would you create a taxonomy to identify key customer trends in unstructured data?
electrical knowelge
When should the volatile modifier be used?
What billing models are supported on BlackBerry App World?
How to see a list of roles and the associated ids in our environment?
Explain Synchronous transmission.
How can we upload the file to the server using servlet?
What is called method in c#?