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
- 1808 Views
- Covansys, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is defect management in QA?
Will automated testing tools make testing easier?
Have you written test plan?
what is the difference between RDBMS and DBMS
On what basis CCB approves the changes?
How does a server or client environment affect software testing?
what is the difference b/w qtp,winnrunner,testdirector?
what is confirmation testing??
What are the key components of a test case template
How many levels of ISTQB Certifications r there? What r they? When they will be commenced?
what r the main benifits of web-logic(application server)
What is code inspection?
Automation Testing 
