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
- 11059 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 are the different types of sql commands?
List the various privileges that a user can grant to another user?
Can we use ddl statements in stored procedure sql server?
tell us something about heap tables. : Sql dba
Does oracle roll back the transaction on an error?
How do I upgrade sql?
what is collation? : Sql dba
Can sql function call stored procedure?
When is a declare statement required?
Is sql an operating system?
What is the difference between explicit and implicit cursors in oracle?
What are predefined functions in sql?
What is a dynamic query?
How do you copy a table in sql?
Why should I use postgresql?
