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 5782Post New Covansys 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)
What is the minimum time for any program scan in pc
Which query language is used in Cassandra database?
Your project was just completed. Due to some unfortunate circumstances, the project was delayed causing cost overruns at the end of the project. This information might be useful on future projects in all of the following activities except: A. Cost estimating B. Allocating resources C. Product verification D. Activity estimating
How will change the frequency in distribution side?
Tell me what are lsi keywords?
How measurements of reaction times can be used to infer brain architecture?
What are selection structures?
However do I automatize reports victimization tableau software?
What is cross join in sql server joins?
Explain process spawning?
What is DML Compiler?
HELLO EVERYONE ON YAHOO , I'M IN NIGERIA AND I Will LIKE TO MOVE AND WORK IN CANADA , ANY SKILLED WORK IS OK BY ME AND THE PERSON WILL PAY THE BILL FOR IT, I WILL SERVE THE PERSON FOR THE EXPENSES.......... LOVE TO READ FROM YOU SOONEST AS YOU WISH TO HELP ME OUT
Tell me should I use print “$a dollars” or “{$a} dollars” command to print out the value of dollars in this case?
The user has an ec2 instance that has an unencrypted volume. The user wants to create another encrypted volume from this unencrypted volume. Which of the following steps can achieve this?
What is the python idle?
