Search results for query: *

I have the following query select oc_name,a.BUSINESS_TITLE_DESCR,count( a.sex) F from ws_sps_ee a,ws_sps_dept b where a.deptid=b.deptid and a.BUSINESS_TITLE_DESCR in ('First Vice President','Vice President','Senior Vice President')and a.sex in('F') group by oc_name,a.BUSINESS_TITLE_DESCR,a.sex...

My query is a.name,b.title,b.sex from tbl a,tbl b where b.title in('Manager','General Manger') group by a.name,b.title i need to bring rows which has count of female population who hold a particular title and also count of male population who hold a particular title. like count of managers...

Hello, I am kinda beginner in sql. I have to bring teh rows of particular value . I have a table which has column where the values X or Y.I need to bring count of the rows which has value X. Thanks for your help

By "where the value (bonus,rating,merit) is 0" i mean either bonus=0,rating=0,merit=0.I wnat to replace the value by character X. Thanks

Hi, I have query which goes like this select b.name,a.id,i.bonus,r.rating,m.merit from sps_ee a,sps_dept b, (select id,ee_att_value bonus from ws_sps_ee_att d where d.ee_class_id=11 and d.ee_att_id=1) i, (select id,ee_att_value rating from ws_sps_ee_att d where d.ee_class_id=7 and...

I have a query which fetches necessary data for all the employees. But now i have to get data for specific people whose employee ids and names are provided. My question is can i hardcode like select........ from....... where empid="12","23"..

Gotit working tahnks

HI, I am very new to sql and am using TOAD. i am getting teh following error. when m.merit is null then 0 else m.merit end as merit when i am trying to execute this statement i got error INCONSISTENT TYPES EXPECTED NUMBER GOT CHAR my question is how to set the value for m.merit zero when it...