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 details4 6337
Post New Covansys MySQL Interview Questions
Explain about executable UML?
What is block level storage?
How do I create a wsdl file?
Is c++ platform dependent?
What is the difference between sap bw 3.5 and 7.0?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Write the syntax for creating a collection and dropping a collection in mongodb.
Define what is the metallurgy use? Define what is the casting and forging?
Why use only splunk?
What is a dataframe spark?
When is an app said to be in active state?
Explain the uses of mrc?
Are rss feeds still used?
Is SAP Business Objects offered as independent BI solutions or is it tied with SAP?
List out the difference between ServletConfig and ServletContext?