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
- 12003 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 transaction control language (tcl)?
What are the subsets of sql?
How do I audit the sql sent to the server?
How many types of relationship are there?
Can we join more than 2 tables in sql?
Is there a 64 bit version of ssms?
How do you take the union of two tables in sql?
What is sqlcommand?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What are sql functions? Describe in brief different types of sql functions?
What is the difference between row level and statement level trigger?
What does partition by mean in sql?
What is output spooling in sql*plus?
How would you convert date into julian date format?
Is ms sql traffic encrypted?
