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
- 11061 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
what is data manipulation language? : Sql dba
Is like operator in sql case sensitive?
How many clustered indexes can you have?
Is mariadb a nosql database?
Can we edit a view in sql?
What are tables and fields?
How to select unique records from a table?
what is the difference between nested subquery and correlated subquery?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the difference between a procedure and a function?
What are the indexing methods?
What is trigger explain with example?
Why is nosql good?
Is sql developer case sensitive?
What do you mean by dbms? What are its different types?
