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
- 1 Answers
- 2499 Views
- Protech, I also Faced
- E-Mail Answers
Answer Posted / Karmendra Prakash
Output1: SELECT Col1 AS col1, col2 AS col2 FROM (SELECT 1 as Col1, 2 as col2 UNION ALL SELECT 2 as Col1, 3 as col2 UNION ALL SELECT 3 as Col1, 4 as col2 UNION ALL SELECT 5 as Col1, 6 as col2) AS temp;nOutput2: SELECT group_concat(Col1 SEPARATOR ',') AS col1, group_concat(col2 SEPARATOR ',') AS col2 FROM (SELECT 1 as Col1, 2 as col2 UNION ALL SELECT 2 as Col1, 3 as col2 UNION ALL SELECT 3 as Col1, 4 as col2 UNION ALL SELECT 5 as Col1, 6 as col2) AS temp;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many tables will create when we create table, what are they? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Is primary key clustered index?
how to use regular expression in pattern match conditions? : Sql dba
What is the current version of postgresql?
what is dbms? : Sql dba
What is the current version of sql?
If a cursor is open, how can we find in a pl/sql block?
how to escape special characters in sql statements? : Sql dba
Can we rollback truncate?
what is bcp? When does it used? : Sql dba
Can we use distinct and group by together?
what are all the common sql function? : Sql dba
what are aggregate and scalar functions? : Sql dba
Do we need to rebuild index after truncate?
