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
- 12019 Views
- I also Faced
- E-Mail Answers
Answer Posted / paul
just tel me is that wat u exactly want
table -Email
email_id user_id
joy@yahoo.com joySmith
waine@gmail.com WaineR
@gmail.com tr222
@yahoo.com huip
if m not wrong in understanding ur question that is u
required the 2 records with emailid as @gmail.com and
@yahoo.com
then u can use the sql statment -with like...
select * from email where email_id like '@%';
email_id user_id
@gmail.com tr222
@yahoo.com huip
hope m correct...
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Why function is used in sql?
What is cursor status?
How do I run pl sql in sql developer?
How do you rank data in sql?
Can we use pl sql in mysql?
What is a recursive stored procedure?
Can we create table inside stored procedure?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is cte?
Is primary key always clustered index?
What is sap sql?
What is the difference between subquery and correlated query?
What is difference between ms sql and mysql?
