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 8265Post New Covansys Interview Questions
How do I boot from usb on windows 10 hp laptop?
What is a main element in coding?
What is webapps folder in tomcat?
What is trace flag definitions in sybase?
What is ember.js?
What is the minimum number of html5 tags that are required to create a web page?
What is spring jdbctemplate class and how to use it?
How do I create a new form in c#?
Explain the primary advantage of multiplexing?
How can an inner class access the members of outer class?
What is a central pattern generator?
Write a program to print fibonacci series without using recursion?
What do you mean by option strict on?
Is postgresql like oracle?
What is shale?