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 7762Post New Covansys MySQL Interview Questions
Can any one please give me a test case for transaction of money thro' mobile phones. I really need it soon. i need the test case in ieee format.please anyone help me.
What is meant by payscale structure?
I have written a pro*C program to fetch data from the cursor. where in i have used the concept of BULK FETCH.... each FETCH statement is taking lots of time to fetch specified number of rows at...
What is jit compilers?
On android, a layout can contain other layout?
What are register variables? What are the advantage of using register variables?
What is OOP Language?
Explain realignment
What is inheritance in term of oop (flash actionscript)?
Which environmental variables impact a marketing plan?
Why do we use web application?
What are inbuilt functions in sql?
What is __ new __ in python?
List primitive java types?
what are the fiber losses,How to rectify it?