Query to decrease commission by 2% for all people living in Mumbai.

Question

question

dineshkumarc asked Feb 18, '16

Query to decrease commission by 2% for all people living in Mumbai.

How can I increase and decrease the same amount of percentage in salary_amount in workers table? i am using oracle sql 11g express edition i have uploaded a image of workers table

query decimal basics

workers.jpg (45.2 KiB)

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

GPO commented · Feb 18, 2016 at 11:24 AM

What have you tried so far? Can you give us an idea of the columns in the tables that you're working with? What RDBMS are you using?

0 ·

GPO commented · Feb 18, 2016 at 11:54 AM

Thanks for updating your question - much clearer!

0 ·

Answer 1 · 2016-02-18T07:23:53Z

vinaygr24 answered Feb 18, '16

Hi Try this... for example,to deduct 2% from all residing in the city of Mumbai: UPDATE workers SET comm=comm*0.98 WHERE city="mumbai"

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dineshkumarc commented · Feb 18, 2016 at 12:11 PM

thanks vinay sir

0 ·

question