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
No Answer is Posted For this Question
Be the First to Post Answer
What r the advantages of automation?
List out various tools required to support testing during development of the application?
What if the project is not big enough to justify extensive testing?
What is the procedure for acquiring CMMI Certification for the company Is CMM no longer used
What is breadth testing?
list potential risks that you have identified so far in Banking domain
What does the software qa document should include?
waht is the difference b/w test caes and test data?
Can u plz tell me the latest version in QTP,WinRunner,Test Director,Quality Center?
pls post the questions for qa position in factset
How is retesting different from regression testing?
what is the difference between lifecycle model and v-model