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
- 4 Answers
- 8231 Views
- CybAge, I also Faced
- E-Mail Answers
Answer Posted / uday kumar_anem
1. select count(*)
from employee
where sal>=20000 and sal<=50000
2. select count(*)
from student
group by course
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is execution?
How should testing be conducted?
What are the valuable steps to resolve issues while testing?
What is a user guide?
How we will do DataBase testing through Qtp application, i know two things 1)Import date from sheet2)Database Check points. But Interviewr asked me How to Run Queries from Qtp Application?Plz Any Body Exlain about Data Base Testing.Urgent.........Advanced Thanks
what is the meaning of Field Level Validation & Form Level Validation??
Set a=description.Create a("name").value="Google" Set b=description.Create b("Title").value="Google" Set c=description.Create c("micclass").value=" webedit" 'c("name").value="q" 'c("type").value="text" 'Set d=description.Create 'd("name").value="q" Set e=description.Create e("micclass").value="webbutton" e("name").value="Google Search" Set h=description.Create h("name").value="qtp - Google Search" Set desc=description.Create desc("micclass").value="webelement" desc("type")="qtp" Set l=description.Create l("title").value="qtp - Google Search" 'invokeapplication"C:\Program Files\Internet Explorer\IEXPLORE.EXE","http://www.google.co.in/" invokeapplication"C:\Program Files\Internet Explorer\IEXPLORE.EXE" Browser(a).Page(b).WebEdit(c).set"qtp" Browser(a).Page(b).WebButton(e).click set z=Browser(h).Page(l).childobjects(desc) i=z.count print i 'For j=0 to i -1 ' m=z(j).getroproperty("text") ' msgbox m ' print m ' 'Next hi guys this is anil. i am beginner in advance qtp. i am trying to write script for searching web element (QTP)in google. i have posted a script plz check it. send me solution how to write scripting for search and counted no qtp word in google search . plz tell me the solution ASAP
How will you log a Defect when you are in the process of executing a test case?
What is structural testing?
Explain how you would allocate a task to team members?
What is incremental analysis?
What are the structure-based (white-box) testing techniques?
How you would allocate a task to team members?
What is negative and positive testing?
Explain usability testing?
