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
- 12157 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
what is recursive stored procedure? : Sql dba
What are the string functions in sql?
What is a mutating table and a constraining table?
What is the maximum rows in csv?
What is a trigger word?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is sql partition function?
Write the command to remove all players named sachin from the players table.
what is self join and what is the requirement of self join? : Sql dba
Is drop table faster than truncate?
What is prepared statement in sql?
Can we create clustered index without primary key?
define join and explain different type of joins? : Sql dba
tell me about various levels of constraint. : Sql dba
What is dynamic query?
