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
- 1903 Views
- Covansys, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is test oracle in testing? Why it is using? What is the advantage when a test oracle is used?
Enlist the priority of the testing tasks defined by the qa team in product development.
What is basic block?
QA Responsibilities?
how we do telecom testing(billing system) give some idea with test cases,test scenario etc
What is the term for decomposing a software program so that latent design information can be extracted? Choice 1 Regression Choice 2 Restructuring Choice 3 Reusability Choice 4 Reverse engineering Choice 5 Reengineering
4 Answers Brainbench Certification,
What are the key components of a test case template
What is exploratory testing and specification-driven testing?
Explain what is mr and what information does mr consists of?
What is boundary testing?
can u share your though about test leakage matrix with template?
What is difference between retesting and regression testing?
Automation Testing 
