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
- 4837 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
what is qtp licence
What is the use of virtual object wizard and how it is used?
What are the modes of script recording in winrunner ?
How to read the third party controls in the application
Hiiiiiiiii This is lavanya.....At present i m working as a MATLAB developer at CMC(A tata enterprise)from about1 year .now i want to move to testing field as a fresher?Is this possible...can anyone give me a suggestion regarding d testing field.....
What are the synchronization points?
Name the three modes of running the scripts?
Explain the use of test director software?
This Is Sekar, Can Any One Of You Help Me? Question: How To Draw Charts In Excel Sheet Using Winrunner Scripts. Thanks, Sekar.
How to break infinite loop?
What is the usage of Test case Design Techniques,in Integration/System Testing?
how can you explain your Real Estate Project in front of interviewer..? please step by step......
Explain data parameterization in winrunner?
Write test scripts on a scenario where you have to transfer data from one table to another.
What different actions are performed by find and show button?
