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 7022Post New Covansys MySQL Interview Questions
- Covansys C++ General Interview Questions (1)
- Covansys PHP Interview Questions (1)
- Covansys Crystal Reports Interview Questions (1)
- Covansys SQL Server Interview Questions (1) Covansys MySQL Interview Questions (1)
- Covansys DB Development Interview Questions (1)
- Covansys WinRunner Interview Questions (2)
- Covansys Load Runner Interview Questions (1)
- Covansys QTP Interview Questions (13)
- Covansys Test Director Interview Questions (1)
- Covansys Rational TestSuite Interview Questions (5)
- Covansys Automation Testing AllOther Interview Questions (4)
- Covansys Manual Testing Interview Questions (42)
- Covansys QA Concepts Interview Questions (6)
- Covansys Test Documents Reporting Interview Questions (1)
- Covansys Testing AllOther Interview Questions (1)
- Covansys COBOL Interview Questions (4)
- Covansys CICS Interview Questions (1)
- Covansys Core Java Interview Questions (2)
- Covansys JDBC Interview Questions (1)
- Covansys XML XSLT RSS Interview Questions (2)
- Covansys Cognos Interview Questions (5)
- Covansys SAP ABAP Interview Questions (1)
- Covansys Oracle Apps Technical Interview Questions (2)
- Covansys SeeBeyond Interview Questions (1)
- Covansys General Knowledge_Current Affairs Interview Questions (1)
- Covansys Aptitude Questions Interview Questions (1)
- Covansys Placement Papers Interview Questions (1)
Why do I need ftp?
What is use of super keyword?
sir im going to face interview of sbi clerk post,so i want to know about the questions which can be asked in the interview?so plz help me.thank u....
How can a customer buy additional service for a product?
What are mambots and plugins?
what is mean by provision ? give me examples ..
Explain what is select clause and where clause in linq?
Explain ovarian cysts. What harm can they do?
What is difference between session and cookies in asp net?
Is access a database?
What is Laravel - File Uploading ?
What is linq and its advantages?
You are working on a project that is similar in scope to a project performed last year by your company. You might consider which of the following? A. Using the previous project's alternatives identification as a template B. Reusing the previous project's benefit/cost analysis as justification for this project C. Using the previous project's WBS as a template D. Reusing the previous project's product description when writing the scope statement
Explain REPEAT function in Hive with example?
Both generator parallel condition shared load equally but one genrator taking ampere more than the other what are all the causes to make like this
