Answer / raji_4u

select substr(mail_id,instr(mail_id,'@',1)) from table_name

This works fine.

Answer / 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...

Answer / amitabha mandal

select substr(mail_id,instr(email_id,'@'),(length
(email_id,'@') - instr(email_id,'@'))+1) from table_name.

Answer / rk

select substr(mail_id,1,instr(mail_id,'@')-1) from
test_rk_mail

Regards,

Answer / mail2sentha

select email_id,user_id,substr(email_id,instr
(email_id,'@'),length(email_id)) from mail_id;

i think its correct?

What do you mean by query optimization?

0 Answers  

what are the differences between binary and varbinary? : Sql dba

0 Answers  

What Is a Trigger? How Do You Use It?

3 Answers  

Compare sql & pl/sql

0 Answers  

What does the sign mean in sql?

0 Answers  

Talk about views

10 Answers   Polaris,

What is dml with example?

0 Answers  

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers  

What are the two different parts of the pl/sql packages?

0 Answers  

What is a constraint?

0 Answers  

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

how view used for security purposes?

3 Answers   Glam India,