i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?
6 14023Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
6 10690Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
4 20063have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
8 14715i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 10774I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
1 3181Post New IBM SQL PLSQL Interview Questions
what is adb in android?
What are internal and external commands in ms dos?
What is cctld?
What are advantages of arc over mrc?
List the applications of stacks?
Elaborate on plinq?
Tell me what is the meaning of a final class and a final method?
What does ctrl m do in onenote?
What folder is my email in outlook 2016?
How can you include collection field in an expression?
What are the Certifications available for Developers in Pega?
What is ecp (equivalence class partition)?
to which generation of prog. languages does ai prog languages belong
What is the spring framework used for?
Explain what is backbone.js?