write a querry .if 10 records in a table.i want only 1
record and 3 reocrd and 10 record. how to write a querry.
Answers were Sorted based on User's Feedback
Answer / sreelatha reddy
suppose you have 10 records in a table.First i will explain
about the structure of the table.
emp Table
Sno sname ssal scommm
1 aaa 3000 400
2 bbb 4000 500
3 ccc 5000 500
4 ddd 6000 600
-
-
-
-
-
10 zzz 8000 800
select * from emp where sno in(1,3,10);
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kishore kumar
select * from table name where rownum in (1,3,10);
| Is This Answer Correct ? | 2 Yes | 0 No |
When usin qtp iam able to get the data from the database only in a single row that is if i have 2 columns in database,when using database output value , all the values in Database are transfered to a single row in QTP datatable. I want the values to appear as it is from the database , can anyone suggest some ideas?
Hi I would like to ask a general question, I finished my post graduation(arts)a long back say 2000. I have a diploma in IT. And I have completed a course in testing(2010). What are my chances of getting a job in testing. I really have an apitude for testing and if given an opputunity I will do well. But I have been sent away after apitude tests which I know I did well(3 or 4 might have gone wrong), hr rounds. Can u tell me if I will get a job at all. Really I feel very let down. Give suggestions that will work thanx
What would you say to your boss if he?s crazy about an idea, but you think it stinks?
how do you test the server response time? do you use any tool? if so what tool ? if not how can you it be done manually ?
One diagram is given find out the diagram
What is coverage analysis?
What is brainstorming?
what r the benifits of continuous testing?
There are two sand clocks(timers) one complete totally in 7 minutes and other in 9-minutes we have to calculate with this timers and bang the bell after completion of 11- minutes!plz give me the solution.
Hi,Iam learning software testing now.i want to put 2+ yrs exp:.Is there any problem with fake exp:.how to prepair for the Interview. Thank u
What it means by test harness?
What is what are the parameters of performance testing?