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 8803Suppose 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 6848Interchange 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.
3 13876have 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 9608i 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 8464I 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 815Post New IBM SQL PLSQL Interview Questions
What to perform pattern match with the like operator?
What is a IdentityMapper and IdentityReducer in MapReduce ?
what is the deference between depreciation explanation
What kind of encryption is used for bluetooth security?
can any one know is sbi interview based on merit or based on roll number
Tell me about your work experience? How has it prepared you for a career at Aeropostale?
What is thin and thick client?
Explain why use mmwc unit?
What is spring java based configuration?
Is silverlight supported on various locales?
What is the difference between osmosis and diffusion?
why genarator genarating voltage 11 KV?
What is state c#?
Is M-ary PSK bandwidth efficient or power efficient
What is the use of hbm2ddl configuration in hibernate?