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 6925Post New Covansys MySQL Interview Questions
What can't you do on unactivated windows?
What is chaining in node?
What are the different ways to store various types of records in salesforce?
How to randomly retrieve a value from an array?
I need exexution process for JCL programs
what are the different types of variables available in cl?
You attended the pre-placement talk, tell us few negative points about the presentation and how should we improvise for the next time?
Tell me about your experience.
How is the system clock calculated in the 8085?
What do you mean by financial accounting?
What are the different input sources for Spark Streaming?
How to get current date in hibernate query?
What is the repository pattern?
How does it work?
Why is java multithreaded?