Create a query that displays the employees' last names and commision amounts.If an employee does not earn commmission, put "No Commission." Label the column COMM.

dev

• Sep 18th, 2006

 

HI,

To retrieve the last names

for example if u have a table 'student' and field as 'name' like sri,ppp where sri is first name and ppp is last name.

select * from student where substr('name',instr('name',',',1,1)+1,length(name)) ='SRI';

then u can get last names.

if u have any doubt then feel free to ask me.

dev.

dev

• Sep 18th, 2006

 

with this u can do:

select coalesce(comm,'no commission') "comm" from mm;

It will replaces null values with 'no commission'.

Rohan Deshpande

• Oct 13th, 2006

 

query:- select last_ename,comm,nvl(to_char(comm),'no commission') comm from emp where comm is null;

elektra

 Profile Answers by elektra Questions by elektra

• Oct 29th, 2006

 

select nvl(to_char(commision),'no commision') "COMM" from jemployee2;

Neeraj

• Nov 7th, 2006

 

Hi,Suppose that you have a table EMP with the following structure.emp_id number(5)f_name varchar2(30)l_name varchar2(30)salary number(8,2)comm number(8,2) /* this column holds the commission values*/Now you can write your query as follows.SELECT l_name, nvl(comm,'No Commission') commission from EMP;The above query will give the desired output.

karthik

• Jan 2nd, 2007

 

Check it out with this Query,select ename,decode(comm,NULL,'NO COMMISSION',comm,comm) from emp;

Rina_S

 Profile Answers by Rina_S 

• Dec 24th, 2007

 

select ename, nvl2(to_char(comm), to_char(comm), 'NO COMMISION') from emp

kssatya.69

 Profile Answers by kssatya.69 

• Dec 29th, 2007

 

select  last_name "LAST NAME", nvl(comm,"NO COMMISSION") commission from employees;

netrasurve

 Profile Answers by netrasurve 

• Jan 3rd, 2008

 

select last_name "Emp LastName", nvl(Comm,"No Comission") "COMM" from employee

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 5th, 2010

 

SELECT ename, nvl2(comm,to_char(comm),'no_commission') FROM employee;

pollysingh544

 Profile Answers by pollysingh544 

• Feb 22nd, 2010

 

Select last name,decode(commision,0,'No Commision',commision) comm from employee