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
- 11977 Views
- I also Faced
- E-Mail Answers
Answer Posted / mail2sentha
select email_id,user_id,substr(email_id,instr
(email_id,'@'),length(email_id)) from mail_id;
i think its correct?
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is the difference among union, minus and intersect?
What are variables in pl sql?
What are the popular database management systems in the it industry?
How do I find sql profiler?
What is right join sql?
how can we know the number of days between two given dates using mysql? : Sql dba
How do you drop a trigger?
What is sql query optimization?
What are sql indexes?
What is the basic form of sql query?
What is the difference between sql and mysql?
Can we rollback truncate?
What is the difference between having and a where in sql?
In a distributed database system, can we execute two queries simultaneously?
Name some usages of database trigger?
