Table1: Col1 col2 1 2 10 3 4 89 5 6 Table:2 Col1 col2 3 2 9 5 4 7 6 87 With the help of table1 and table2 write a query to simulate the fallowing results. Output1: Col1 col2 1 2 2 3 3 4 4 5 5 6 Output2: Col1 col2 2 3 10 4 5 89 6 7 1.Write query for single row to multiple row using sql statements. Eg:a,b,c,d,e,f Change to A B C D E F 2. Write query for multiple row to single row using sql statements. Eg2 A B C D E F Change to Eg:a,b,c,d,e,f Table1: Col1 col2 8 5 2 9 4 2 5 1.Write a query to select all the rows from a table1,if the value of A is null then corresponding B’s value should be printed in A’s value.if the value of A is null in that table then corresponding B’s value should be printed as 30. 2. write a query to find the sum of A and B .display the max among both. 3.write a query to find total number of rows from table 1. Note: if any column value is null in a row then that row should be considered as 2 rows. 4.write a query to display all the records of table1 except A containg 2 as well B containg 5. 5.rewrite the fallowing without using join and group by. Select b.title,max(bc.returneddate –bc.checkoutdate)” mostdaysout” From bookshelf_checkout bc, Book shelf B Where bc.title(+)=b.title Group by b.title. 6.rewrite fallowing query Select id_category from category_master X where exists (select 1 from sub_category Y where X.id_category=Y.id_category) Customer: Name phone1 phone2 phone3 bitwise A 23456 67890 12345 --- B 67459 89760 37689 --- Don’t_call Col1 67890 37689 1.q) update the customer table of bitwise with 1 or 0. Exists in don’t_call table menas show -1 Other wise -0. Output. Name bitwise A 010 B 010

1200

please let me know how to show the sales to unregisterd dealers in tn ctd new portal and in which annexure to select for filing sales to unregisterd dealers, cash / consumer sales

642

What does ‘jps’ command do?

1

what type of question are asked in thoughtworks pair programming round ?

697

what is functionality of polymer? how can we get theoretical and practically?

1260

How to estimate peptone ?

898

what is bailout fund and what are the main drawbacks of bailout funds? what is the role of bailout fund in an economy and what are the impact of bailout fund on market , economy , the bailout provider and the bailout reciever?

1130

Who invented machine learning?

1

write a sql query retrive all xml data. how to retrive xml data wit single sql query.

1319

how to answer the question tel me about your project

838

Discuss the following terms with respect to ATM: VPI, UNI, asynchronous, AAL, Cell, PVC.

459

WE HAVE SOLD GOODS ON 20.09.2010 TO X AND IT HAS BEEN RECODED BY X IN HIS BOOKS ON 08.10.2010 ACCORDINGLY X HAS ISSUED FORM C IN THE QR.OCT-DEC IS IT ALLOWABLE UNDER CST ACT.

2396

Pl. give me checklist for installation & commissioning of machine tool.

1101

what is new updates in account

883

I have 2500KVA transformer delta/star,13.8KV/380V provided with LV 4000A breaker. Already I have 2300KW motor feeder with a full load 90%. Is it possible to connect another 1600A from that breaker? If so how the calculation is done?

2622