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
- 3585 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you call windows APIs, explain with an example?
global sheet and external excel sheet how it will work
what is mean by release in quality center and who will perfom?
Welcome link is dynamic. How do you handle? What is your approach and write script.plz send answer
Hi iam a begginer or rather new stsrter to QTP and strugling to start as i have to start writing the automated scripts for the existing manual testing could some one send me some tips ans tricks for a jump start. Any help is greatly appreciated
What is test parameter
How do you find an object in an gui map.
Explain the winrunner testing process?
When it is appropriate to change physical description?
How do you maintain the document information of the test scripts?
What is the purpose of gui spy?
What is boundary test?
Explain the purpose of gui map configuration?
Which are default codes winrunner generates when we start the application?
How do you identify which files are loaded in the gui map?
