write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

CTS,

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

Tech Mahindra,

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

TCS,

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

TCS,

Which of the following statements is false? If your Frame Relay link does not support inverse ARP, you must manually map DLCIs to network Address. One of the major advantages of Frame Relay is its ability to connect to multiple PVCs using only one physical link. DLCI addresses are determined by the network administrator when installing the network. Which of the following statements is false? If your Frame Relay link does not support inverse ARP, you must manually map DLCIs to network Address. One of the major advantages of Frame Relay is its ability to connect to multiple PVCs using only one physical link. DLCI addresses are determined by the network administrator when installing the network. In order for two ends of virtual circuits to communicate using Frame Relay, their network addresses must be mapped to DLCIs.

Wipro,

i want run following code on button click of view. i am trying to retrieve data from isc_order_details table and isc_product table. but after retriaval of data i m getting error like FIELD MUST BE ENTERED!! DECLARE m number; n number; CURSOR order_details IS SELECT PRODUCT_ORDER_QUAN,PRODUCT_ID FROM isc_order_details WHERE order_id=:isc_order_master.order_id; amount NUMBER (8,2):=0.0; alert number; BEGIN go_block('isc_order_details'); first_record; m:=:system.cursor_record; last_record; n:=:system.cursor_record; OPEN order_details; --for i in m..n loop FETCH order_details INTO :ISC_ORDER_DETAILS.PRODUCT_ORDER_QUAN,:ISC_ORDER_DETAIL S.PRODUCT_ID; IF order_details%FOUND THEN SELECT order_value,order_date INTO :ISC_ORDER_MASTER.ORDER_VALUE,:ISC_ORDER_MASTER.ORDER_D ATE FROM isc_order_master WHERE order_id=:ISC_ORDER_MASTER.ORDER_ID; SELECT product_desc,product_price INTO :ISC_ORDER_DETAILS.PRODUCT_DESC,:ISC_ORDER_DETAILS.PROD UCT_PRICE FROM isc_product WHERE product_id=:ISC_ORDER_DETAILS.PRODUCT_ID; next_record; END IF; EXIT WHEN order_details%NOTFOUND; END LOOP; last_record; CLOSE order_details; EXCEPTION when NO_DATA_FOUND then alert:=SHOW_ALERT('ENTER_DATA'); Go_Item('isc_order_master.order_id'); END;

Zensar,

why not soot blowing performed of air preheater, while soot blower is in retract position?

. Write a C program to perform following functions:- a. Declare one integer variable of all the storage classes. b. Print all the variables without assigning any values in tabular format. a. The tabular format must contain the variable name, type, storage class and printed value on the screen in RED color.

any one help me how the following program execute main() { int x=5; printf("%d %d %d",x,x<<3,x>>2); } //output : 5 40 1

Read the following program carefully and write the output of the program. Explain each line of code according to given numbering. #include #include #include #include 1……………… int main (void) { pid_t pid; 2………………………… pid = fork(); 3…………………………. if (pid > 0) { int i; 4………………………… for (i = 0; i < 5; i++) { 5………………… …………… printf(" I AM VU : %d\n", i); 6………………… …………… sleep(1); } exit(0); } 7………………… ……… else if (pid == 0) { int j; for (j = 0; j < 5; j++) { 8……………………………… printf(" I have no child: %d\n", j); sleep(1); } _exit(0); } else { 9………………………………fprintf(stderr, "can't fork, error %d\n", errno); 10……………… … ………… exit (EXIT_FAILURE); } }

i have SAP B1 in my work area When i am try to hold the particular item the following ERRORS display in my System (This entry already exists in the following tables '' (AIT1) (ODBC -2035) [Message 131-183])

how do i commission a distribution transformer knowing all its ratings and transformation ratios?d

Draw a pipeline configuration to carryout the following operations on the arrays of data represented by A, B, C, D, E and F. (A i represents the i th element of the array). (Ai × Bi + Ci × Di ) (Ei × Fi ) Show the content of the pipline for i = 1 to 5

Omega Healthcare,

can u give result for the fallowing example... 05 a pic 9(2) 05 b redifines a pic x(2). move 'xy' to b. display a,b.

IBM,

How to get Cv of control valve having following parameter ,i.e inlet pressure 4.5kg/cm2 outlet pressure 1 kg/cm2 specific gravity 0.808