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
- 11784 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 having without group by in sql?
When is a declare statement required?
Is drop table faster than truncate?
How to make a copy values from one column to another in sql?
how to fetch alternate records from a table? : Sql dba
What are different methods to trace the pl/sql code?
What are two statement types in sql?
How do you update sql?
What does desc stand for?
How can one get sql*loader to commit only at the end of the load file? : aql loader
Is pl sql better than sql?
Why left join is used in sql?
What is a clob in sql?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Explain spool.
