Interested to Buy Any Domain ? << Click Here >> for more details...
What are all the difference between Like and Contains ?
- 2 Answers
- 11010 Views
- LG Soft, I also Faced
- E-Mail Answers
Answer Posted / rubyna
Like gives additional option of specifying exact
string/character position in the text. eg. if we want to
search all words having second letter 'a', we can use like,
but cannot use contain-
select * from emp where emp.name like '_a%'.
We don't have corresponding statement with contains.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Why do we need sharding?
Explain about various levels of constraint.
What is a database trigger?
Is subquery faster than join?
what is the difference between $message and $$message? : Sql dba
What is query optimization in sql?
how to create a table index in mysql? : Sql dba
What is application trigger?
What are pl sql data types?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
How to check if a column is nullable before setting to nullable?
Can we rename a column in the output of sql query?
Define SQL and state the differences between SQL and other conventional programming Languages?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What port does sql server use?
