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 8255Post New Covansys MySQL Interview Questions
What are the services in RMI ?
What is the use of endl?
how can a cgi check whether an ifs object is available?
In support project one ticket alloted which steps follows manualy tell me ?
What is relationship in nifi dataflow?
What is strong name in .net assembly?
What quality of yours or personal trait matters the most in your career at Disney Store?
What is the domain testing?
If we take 2 strings as “good” and “bad” then what will ‘+’ and ‘&’ operators return?
Difference between call by value and call by reference in C#?
Explain materialized views and how they are used.
What is data cleaning? How can we do that?
Explain table queries and select queries.
example of a time you have placed yourself in a leadership position.
What are espots and how do we manage them?