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 13885Suppose 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 10515Interchange 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 19919have 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 14496i 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 10669I 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 3086Post New IBM SQL PLSQL Interview Questions
Explain each() function in jquery?
What is the unit of ph?
How continental heat flow is produced?
Briefly explain input and put function?
What would you not put the shared module?
What is abstract class in ios?
Can master pages be nested?
Can pojo have constructor?
what is Mineralcrisis?
What are the features of ms excel 2010?
How do you run a java program?
Please brief me about number of pole in alternator.In single phase alternator coils are connected in star or series. How to calculate frequency for the same.
What is the current latest version of Scala?
What is meant by shell and tube heat exchanger?
How do I seed my database for column that is a foreign key referencing to other table?