Interested to Buy Any Domain ? << Click Here >> for more details...
mail-id table contains two columns(email_id,userid)
it contains different types of mail-ids,and no of users.
here username length is differ na,(ex-
tamil@yahoo.com,joshua@hotmail.com like)
now i want to fetch the email-ids only starting from '@'
(ex-@gmail.com,@yahoo.com,@hotmail.com
- 5 Answers
- 11988 Views
- I also Faced
- E-Mail Answers
Answer Posted / paul
just tel me is that wat u exactly want
table -Email
email_id user_id
joy@yahoo.com joySmith
waine@gmail.com WaineR
@gmail.com tr222
@yahoo.com huip
if m not wrong in understanding ur question that is u
required the 2 records with emailid as @gmail.com and
@yahoo.com
then u can use the sql statment -with like...
select * from email where email_id like '@%';
email_id user_id
@gmail.com tr222
@yahoo.com huip
hope m correct...
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Can we use distinct and group by together?
What does the argument [or replace] do?
What does 0 mean in sql?
How show all rows in sql?
what is primary key? : Sql dba
what is bcp? When is it used?
What is Materialized View? In What Scenario we Use Materialized View?
Why use stored procedures?
How do I view tables in sql developer?
how to see the create table statement of an existing table? : Sql dba
How many tables can a sql database have?
What is index example?
Can dml statements be used in pl/sql?
What is the difference between partition and index?
What are the datatypes available in pl/sql ?
