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 8587Post 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)
How is AI used in procedural content generation?
what is collation? : Sql dba
sir i am appearing in railway exam of section engineer and my branch is chemical engineering i want previous question paper of section engineer of chemical branch please tell me as soon as possible my email id is surendrasaroj18@gmail.com THANKYOU
Realized?
On a scale of one to ten, rate me as an interviewer now 26 which stack is used in 8086?
please give some hindalco placement papers for written exam
can anybody send the project you have tested with the clear descriptions,and recent bugs u found in that
Hi, If anyone has base SAS certification dumps, please share.
What will be the Salary of a fresher in Dell company for non-voice process?
Study the attached ACS 790 AHU and boiler GUI and refer to the video on the software usage, catalog and the step by step document (page 9) to perform the following task: List in a table form the controllers and all their connected I/O for the boiler and the AHU.
any body plz send health care domain project to me with explanation any two modules on that project. mail_id: ranjith_99reddy@yahoo.co.in
what is total power generation capacity in india at present (as on 12-12-2011)
how to create user name stape by stape in cisco router {with command}
What is a coalesce function?
How can you track any change in model attribute value?
