Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: saina
- Content: Threads
- Order by date
-
selecting....
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... -
bringing a particular value
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 -
Selecting specific data
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... -
data types question
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...
