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
- 11937 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 to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is the difference between function, procedure and package in pl/sql?
what is difference between delete and truncate commands? : Sql dba
What is sorting in sql?
How is pl sql different from sql?
What are the different types of a subquery?
what is 'mysqlimport'? : Sql dba
what are different types of collation sensitivity? : Sql dba
How does a trigger work?
Describe different types of general function used in sql?
What does seeding a database mean?
What is the purpose of a sql?
Explain what is a database?
When you have to use a default "rollback to" savepoint of plvlog?
What is difference between my sql and sql?
