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
- 10384 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 do you delete duplicates in sql query using rowid?
What is the most common sql injection tool?
What is the example of procedure?
What is indexing oracle sql?
What is natural join in sql?
What is user defined functions?
Is natural join and inner join same?
What is sql and explain its components?
What is a sql select statement?
What are the limitations of sql express?
How can I see all tables in sql?
How is a PL/SQL code compiled?
what are all the common sql function? : Sql dba
What are instead of triggers?
What is the difference between an inner and outer join?
