Ask Questions & Get Answers at ibibo sawaal
     Powered by Bixee Crawl
Results 1 - 15 of about 673 sawaal for "dept"
Sort by: Recency | Relevancy

How does one code a matrix/crosstab/pivot report in SQL?

SQL> SELECT DECODEMODv.row,3 2 ,1, Number: ||deptno 3 ,2, Name: ||dname 4 ,0, Location: ||loc 5 AS "DATA" 6 FROM dept, 7 SELECT rownum AS row FROM userobjects WHERE rownum < 4 v 8 queries: SELECT FROM SELECT job, sumdecodedeptno,10,sal DEPT10, sumdecodedeptno,20,sal DEPT20, sumdecodedeptno,30,sal DEPT30, sumdecodedeptno,40,sal DEPT40 FROM scott.emp GROUP BY job ORDER BY 1; JOB DEPT

Posted in Computers & Technology by NirashSoni at 3:33 AM on November 08, 2008
Tags code, report, sql

How does one code a matrix/crosstab/pivot report in SQL?

:SELECT FROM SELECT job, sumdecodedeptno,10,sal DEPT10, sumdecodedeptno,20,sal DEPT20, sumdecodedeptno,30,sal DEPT30, sumdecodedeptno,40,sal DEPT40 FROM scott.emp GROUP BY jobORDER BY 1;JOB DEPT10 DEPT20 DEPT30 DEPT40--------- ---------- ---------- ---------- ----------ANALYST 6000CLERK 1300 1900 950MANAGER 2450 2975 2850PRESIDENT 5000SALESMAN 5600Here is the same query with some fancy headers and totals

Posted in Computers & Accessories by jitendra at 7:54 PM on December 09, 2008
Tags code, report, sql

What is fee for mtech it in karnataka open state university, i couldnt find on their website.

of studies in ComputerScience University of Mysore and PG Depts, Regional Centres & Extension Centres of VTU & institu...Here is the detailed information for Karnataka MTech 2008,Applications, and Department of studies in ComputerScience University of Mysore and PG Depts, Regional Centres & Extension Centres of VTU & institutions affiliated to Visvesvaraya Technological University for the year

Posted in Computers & Technology by Pushpinder at 1:11 AM on July 15, 2008

what is level 49 signifies

want that if name of a person is of 20 chars only, rest 30 chars positions could be reused than to leave the space unused.EX. Say our Rec is01 EMP-REC 05 EMPID PIC X10. 05 DEPT PIC X20. 49 NAME PIC X50 could be reused than to leave the space unused.EX. Say our Rec is01 EMP-REC 05 EMPID PIC X10. 05 DEPT PIC X20. 49 NAME PIC X50. 49 ADDRESS PIC X50. And if NAME is PRADEEP i.e. using only 7 chars out

Posted in Computers & Technology by blogger01 at 10:32 PM on June 06, 2008

I am commerce graduate. i want job in purchase dept, accounts dept as a fresher. pls reply.

You can join in any chartered accountant firm. They have many refference job in many places. Once you join you will get good atmoshpire. You join in with them you wil get fresshers job easily.

Posted in Jobs & Careers by Babu Bhai at 3:15 PM on September 26, 2008

i am working as a manager advertiseing in print media & i face some problem in my dept.bcz i am new joining.so pls. tell me how i manage my dept.

Well all new comers have problems so its normal .I would suggest knowing properly what is expected of you in the job and then having a chat with your subordinates and updating them of this and asking their co-operation in achieving those objectives . You can also possibly advise them of what rewards

Posted in Jobs & Careers by devabrata at 4:47 AM on May 07, 2008

which one is better in hotel line as a career reception and book keeping, resturant and counter service,bakery and confectionery,house keeping, and cookery

be thruout the duty hours. Lacking these - you are not fit for this dept. Income is not very HIGH. Scope of growth in hotel is very less.2. Food & Beverage Service Restaurant & Counter Service - Command on language is very much required but not the most important factor. You need to be smart, prompt & presentable. There is no fixed shift or duty hours for the staff of this dept. You must have

Posted in Others by diwaker at 5:04 PM on May 12, 2008
Tags

which one is better in hotel line as a career reception and book keeping, resturant and counter service,bakery and confectionery,house keeping, and cookery

be thruout the duty hours. Lacking these - you are not fit for this dept. Income is not very HIGH. Scope of growth in hotel is very less.2. Food & Beverage Service Restaurant & Counter Service - Command on language is very much required but not the most important factor. You need to be smart, prompt & presentable. There is no fixed shift or duty hours for the staff of this dept. You must have

Posted in Miscellaneous by diwaker at 5:04 PM on May 12, 2008
Tags

How does one code a matrix report in SQL?

....Look at this example query with sample output:SELECT FROM SELECT job,sumdecodedeptno,10,sal DEPT10,sumdecodedeptno,20,sal DEPT20,sumdecodedeptno,30,sal DEPT30,sumdecodedeptno,40,sal DEPT40FROM scott.empGROUP BY jobORDER BY 1;JOB DEPT10 DEPT20 DEPT30 DEPT40--------- ---------- ---------- ---------- ----------ANALYST 6000CLERK 1300 1900 950MANAGER 2450 2975 2850PRESIDENT 5000SALESMAN 5600

Posted in Computers & Technology by ahshan at 7:20 PM on December 09, 2008

How can u Cheat the Railways dept?

fodne ka shauk ho to, engine khud chala ke 2 train ki takkar kara do...Railway department ke sath waise hi bahot si cheating or ghotale hote rehte hain.........fir bhi aap agar jaana chahte ho ki unhe hum kaise cheat kar sakte hain to uske tarike nimnlikhit hain..........1. Train ki chhat par baithka

Posted in Comedy by dimplepasricha1980 at 5:21 PM on October 22, 2009
Refine By Date
sawaal signature
sawaal free visiting card