Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys pls any one help me , I am facing this problem since
last one week ,
my question is
in there 1000 rows and 1000 coloums , i want to pick the one
record , how ?
- 1 Answers
- 4840 Views
- I also Faced
- E-Mail Answers
Answer / themba tjnas ngobeni
Hi, If you already know what record to pick then before
recommend what you need to do:
1. do you know how your table structure looks like? I guess
u know but do you have indexes build on your major select
columns?
2. irrespective of how many columns are there if you know
how to describe your table you will know which columns are
of importance to you.
With that I will recommend this:
Write your sql statement similar to:
1. Select *
From My_table
where major_column = :my_value --Primary key view all
columns
2. Select *
From My_table
limit 1 -- without primary key but view all columns
3. Select my_column1,my_column2,my_column3, etc
From My_table
where my_column1 like '%:my_value%' -- without using
primary key
limit 1
you can still write more sql statements to achieve the same
results if you want to be vendor specific like Oracle you
can use limit 1 or rownum =1 etc.
I hope this answers you questions.
Regards
| Is This Answer Correct ? | 2 Yes | 2 No |
What are the reasons Winrunner fails to identify an object in the GUI?
3 Answers Bristle Cone, Logica CMG,
How to handle exceptions in for loop of DDT script.
what is the TSL statement to find current systsem date?
How to test Fonts and its size thru "Font Expert" in Win Runner.
Wat is the defferances between Test plan and devolopment plan?
can any body tell me in detail about ERP domine?
hi i am unable to do select the flight in the flight table like list_select_item ("Flight",v_Select_Flight); v_Select_Flight=19072 LON 08:00 AM LAX 10:00 AM AF $161.90 why it is happining pls clarify me doubt
What is boundary test?
hi this is uday iam trying for testing job with 3+ yrs of exp if u have qtp faqs materil plz send me thanks in advance
What are different types of checkpoints?
how can you explain your Real Estate Project in front of interviewer..? please step by step......
did you winrunner architecture
WinRunner 
