Interested to Buy Any Domain ? << Click Here >> for more details...
I have table name in that I have
Rajesh
Reshika
Priya
I want the result Like only Starting with R
Rajesh
Reshika
Can someone help me to get these results and How?
- 3 Answers
- 6543 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
SELECT * FROM TABLE NAME LIKE'R%'
OR U CAN USE SUBSTRING
SUBSTRING(RAJESH,1,1)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do we call shell scripts from informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Mention some types of transformation?
What is rank index in rank transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Explain lookup transformation source types in informatica
What is session task and command task?
Briefly define a session task?
What is source qualifier transformation in informatica?
Explain the use of aggregator cache file?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a dimensional model?
What are the differences between oltp and olap?
What is the advantage of informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
