write a querry .if 10 records in a table.i want only 1 record and 3 reocr

Advertise your Business Here

Refer this Site

Login | Sign Up


	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

Categories >> Software >> Testing >> Testing AllOther

Automation Testing Interview Questions

Manual Testing Interview Questions

QA Concepts Interview Questions

Mobile Testing Interview Questions

Test Cases Interview Questions

Test Documents Reporting Interview Questions

Testing AllOther Interview Questions

Question

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.

Question Submitted By :: Manoj

I also faced this Question!!

Rank

Answer Posted By

Re: 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.

Answer
# 1

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 ?

1 Yes

0 No

Sreelatha Reddy

Re: 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.

Answer
# 2

select * from table name where rownum in (1,3,10);

Is This Answer Correct ?

0 Yes

0 No

Kishore Kumar

Question	Asked @	Answers
Other Testing AllOther Interview Questions


What is the point of reference by which something can be measured? 1. Benchmark 2. Baseline 3. Metric 4. Measure 5. Indicator		3
I'm interested to build my career in testing and I don't have much knowledge which book is good to refer. Can anybody please share some books names ?		3
Will you write a test plan in all phases?	Accenture	9
what is opaque testing?,what is transparent testing	HP	3
Best Testing tools institute in Hyderabad?Suresh Reddy'S Smart Solutions ,HYD Ph:040-64521103/05/06.		2
Hi, Can nybody tel me the how much a Manual tester should know about Database and its connections with the web application?		3
what is the difference between web application and client server application testing ?	NCR	2
Ref.doc.name \| Section \| module \| Testcase ID\|Testcase description\|Test Input \| Expected Result \| Actual Result \| Status for the above format give one example		1
My Qualification is MA can I join Testing Tools Course and Which one is the best Institute for Testing in Hyderabad?		2
In the Software Testing What is Test Report and Bug Report? Is Tester Job to give Bug Report or Test Leads Job?		1
what are the key factors for performance testing ?	HCL	2
what is trigger? What is stored procedures? What is a cursor?	SumTotal	2
With the help of Bug Id how will u find in which module or in which test case a bug hv been arised... ie hw will u track down the bug.....		4
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	CybAge	4
What are the Roles of Team Lead ?	HCL	2
what is the difference between defect management tool and tesecase managment tool, what are its purpose, does QC and TD use for both(defect &test case managment)		1
Which was the first game introduced Bullet Time Future a) Matrix path of Neo b) Serious Sam c) Max Payne d) War craft	EA-Electronic-Arts	3
How to test online application.	TCS	1
why does software have bugs		3
What are the different Metrics followed in the project?	Cap-Gemini	1

For more Testing AllOther Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2009 ALLInterview.com. All Rights Reserved.

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