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
- 11930 Views
- I also Faced
- E-Mail Answers
Answer Posted / amitabha mandal
select substr(mail_id,instr(email_id,'@'),(length
(email_id,'@') - instr(email_id,'@'))+1) from table_name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is sql server agent? : Sql dba
When to use inner join and left join?
How do you get column names only for a table (sql server)?
What do you mean by rowid?
What is scalar function?
What is the difference between delete, truncate and drop command?
Can you upgrade sql express to full sql?
In a distributed database system, can we execute two queries simultaneously?
What are the different sql commands?
What are the advantages of pl sql?
What is the benefit of foreign key?
What are some emotional triggers?
How do I order by ascending in sql?
Does a user_objects view have an entry for a trigger?
What is sql*plus?
