Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 5796 Views
- HealthTech, I also Faced
- E-Mail Answers
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 |
Test report?
Explain what test deliverables is?
What is difference between JBOD and RAID?
how to download fullversion of JIRA(defect reporting s/w) s/w for free.can any provide web site for full version free download.
What is sei - software engineering institute?
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
Do you know what the mean of cmm and tmm?
what is system testing?
What n+1 testing is?
Hello Friends, I am one of the member in this group. I want to know that "Is there a future in Testing field (Black box Tester)". Do any of the Testing Genious can answer with explanation for my Query. sorry if i hurted any Testers by asking this type of questions.
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
how can we identify a bug is because of s/w error or OS problem?
Automation Testing 
