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
- 12000 Views
- I also Faced
- E-Mail Answers
Answer Posted / rk
select substr(mail_id,1,instr(mail_id,'@')-1) from
test_rk_mail
Regards,
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How do I find duplicates in a single column in sql?
What is the difference between view and stored procedure?
What are all the different normalizations?
What are the different sql commands?
what is the use of double ampersand (&&) in sql queries?
Can we use view in stored procedure?
What is full form of rtm?
How do you take the union of two tables in sql?
How many types of normalization are there?
what is sql server agent? : Sql dba
What is over () in sql?
How do I order columns in sql?
How can I see all tables in sql?
How does cross join work?
What is mutating error?
