hi,
they have given 2 tables to write quries in SQL SERVER 2000
based on table as follows .
1st table :author:
COLUMNS AS FOLLOWS
pk. AUTHOR
F_NAME
DOB
NATIONALITY
2ND TABLE BOOKS:
COLUMNS AS FOLLOWS;
PK ISDN
F.K AUTHOR
LANGUAGE
PUBLISH_DATE;
1) RETRIVE author who is indian and hindi
write in a) as joins b) sub quries
2)retrive who is younger author ;
3)retrive author who wrote more than one book in different
language.
4)retrive author who has wrote in different language in
each year
write all queries in sql for sql server
- 0 Answers
- 1805 Views
- Covansys, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are the table contents in testplans and test cases?
In Software Development Team, Who has the biggest and smallest salary? Can You list all of it? It say that SQA Tester is the smallest one, Is it right?
Can any body worked in QA in Finincail / Trading experience. i appreciate if you ans my some questions.
where can i find latest software quality interviews questions
What is the risk factor problem related to project? risk factor ratio in the project?
My friend bought a test management system just recently after comparing a lot of products. But its performance was not quite up to the mark. Please suggest a good one that is worth the money.
What is the role of QA in a development project?
what is peer review?
what is entry and exit criteria?
what is Agile Testing and who will involve and when will u perform this testing ??
What is the difference between preventative and reactive approaches in testing?
Enlist the priority of the testing tasks defined by the qa team in product development.
Automation Testing 
