ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Testing  >>  Testing AllOther
 
 


 

 
 Automation Testing interview questions  Automation Testing Interview Questions
 Manual Testing interview questions  Manual Testing Interview Questions
 QA Concepts interview questions  QA Concepts Interview Questions
 Mobile Testing interview questions  Mobile Testing Interview Questions
 Test Cases interview questions  Test Cases Interview Questions
 Test Documents Reporting interview questions  Test Documents Reporting Interview Questions
 Testing AllOther interview questions  Testing AllOther Interview Questions
Question
Write a query to find the number of employees who got more 
that 20,000/- and 50,000/- sal

Write a query to find the number of sudents in each course
 Question Submitted By :: Uday Kumar_anem
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Write a query to find the number of employees who got more that 20,000/- and 50,000/- sal Write a query to find the number of sudents in each course
Answer
# 1
assuming emp-id and sal tobe the fields in the 
table "Employee" followng query can be used

Select emp-id, sal from Employee where sal between "20000" 
and "50000"
OR
you have to run two different queries to extract records as 
selecting records above 20,000 would cover the second part 
too

2. select count (stud_id) from Student where 
course_name="Testing"

hope they would help
 
Is This Answer Correct ?    0 Yes 0 No
Vishal
 
  Re: Write a query to find the number of employees who got more that 20,000/- and 50,000/- sal Write a query to find the number of sudents in each course
Answer
# 2
here they want number of employees not empno.
select count(empid),sal from emp where sal between 20000 
and 50000;
 
Is This Answer Correct ?    2 Yes 0 No
Krishna
 
 
 
  Re: Write a query to find the number of employees who got more that 20,000/- and 50,000/- sal Write a query to find the number of sudents in each course
Answer
# 3
oh sorry i missed it..

thx for correcting me :-)
 
Is This Answer Correct ?    0 Yes 0 No
Vishal
 
  Re: Write a query to find the number of employees who got more that 20,000/- and 50,000/- sal Write a query to find the number of sudents in each course
Answer
# 4
1.  select count(*)
    from employee
    where sal>=20000 and sal<=50000

2. select count(*)
   from student
   group by course
 
Is This Answer Correct ?    1 Yes 0 No
Uday Kumar_anem
 

 
 
 
Other Testing AllOther Interview Questions
 
  Question Asked @ Answers
 
I have took training in software testing and I don't have much experience before going to start my career I want to get knowledge on testing...please suggest.  2
what is the actual time to stop testing a product.  2
Explain Quality centre? how companies follow the process?  1
What is mean by release notes? TCS1
WHAT IS MEAN BY DESIGNING THE APPLICATION AND CODING THE APLICATION? TCS4
What is Test Server?  1
What is Use case? TCS1
what is the difference in between defect age and build interval period?  1
what is the difference b/w functional testing and system testing?  4
Ref.doc.name | Section | module | Testcase ID|Testcase description|Test Input | Expected Result | Actual Result | Status for the above format give one example  1
Raju has two candles with same size ,differ in thickness, one burns 6 hours and other is 4 hours, before going to bed, raju has observed that one candle is double than other. After how many hours he has seen that? Satyam3
what is port testing Infosys1
What is bottlenecks? Explain with example.  1
Will you write a test plan in all phases? Accenture7
What r SQA activities? MBT4
What is API testing?  2
generally what they ask in a client interview.regarding projects what they might ask?  2
How should I prepare for CSTE Exam?What should I do as I am not having any idea about it? How to register , what r the study materials,validity of certificate.Pls help  1
How to find out duplicate records in a table(Query) CybAge3
What do you think is a good investment, a defect tracking system or a test management system integrated with a defect tracking tool? Please suggest.  2
 
For more Testing AllOther Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com