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
- 11783 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 usage of the distinct keyword?
What is normalisation in sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is difference between procedure and trigger?
What is the use of sqldataadapter?
What is snowflake sql?
Explain alias in sql?
How do I find duplicates in a single column in sql?
What is hibernate and its relation to sql?
what is 'mysqlimport'? : Sql dba
What is the difference between inner join and natural join?
How to display Row Number with Records in Oracle SQL Plus?
What are the different types of triggers?
how can you create an empty table from an existing table? : Sql dba
What is pl sql collection?
