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 4621Post New Covansys Interview Questions
Have you worked with context handling?
what types of electrical & mechanical test conducted in switchyard?
Q. 4 Give a relationship between concept, Hypothesis and Theory. What are the Salient features and classifications?
What is proteosome inhibitor?
what is meant by k-rating in isolation transformer?what is k9, k14 stands for?
Can we use the flyash bricks in brick bat coba?
in filepooling concept if the file doesnt go to target location then it is error directory how to solve this problem
write a programe to calculate the simple intrest and compund intrest using by function overlading
What is the alternate solution for testing of polarity by using polarity tester while its milli ammeter does not works?
graphaite has higher melting point than fularine
Give two methods you could use to determine what DDL changes have been made.
how we Set up Central User Administration (CUA) to manage 4 systems/clients
what is the step in preparing the schedule of audit? can someone explain for me?
In csae of hume pipes NP stands for Non Pressure bur what does it really mean?
what are the dimensions for 200 kva transformer plinth (plateform),in which pcc m20 is used..
- C++ General (1)
- PHP (1)
- Crystal Reports (1)
- SQL Server (1)
- MySQL (1)
- DB Development (1)
- WinRunner (2)
- Load Runner (1)
- QTP (13)
- Test Director (1)
- Rational TestSuite (5)
- Automation Testing AllOther (4)
- Manual Testing (42)
- QA Concepts (6)
- Test Documents Reporting (1)
- Testing AllOther (1)
- COBOL (4)
- CICS (1)
- Core Java (2)
- JDBC (1)
- XML XSLT RSS (2)
- Cognos (5)
- SAP ABAP (1)
- Oracle Apps Technical (2)
- SeeBeyond (1)
- General Knowledge_Current Affairs (1)
- Aptitude Questions (1)
- Placement Papers (1)
