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 13868Suppose 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 10492Interchange 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 19909have 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 14473i 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 10657I 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 3084Post New IBM SQL PLSQL Interview Questions
Is there a way to detect whether fbclient.dll or tbembed.dll is loaded?
What are biomass pyramids? What do they represent?
What is the purpose of dispatcherservlet properties?
Explain the function of nameserver?
How to calculate the copper in HT motors if KW, RPM & Voltage is given
What are main valuation methodologies?
What is the purpose of the master database?
Tell me which has more efficiency: Diesel engine or Petrol engine.
How do I move the taskbar?
Can anybody please refer the best and simple book for about Protection relays and in detail of all its protection ?
what is the syntax used for partition in tsql? : Transact sql
How to calculate the angle in electrical transmission line
define sql update statement ? : Sql dba
I need to ask you that while I am trying to book one person in training for a business event type, they are saying that this person is not available for the business event. Why is it so? But that I can book a user for the same business event type. What is the differense between user and person? Now in case if I book a person for the business event, how can I see whether that person is available for that date or not. Moreover how can I see that that person is on leave or not.
How do you remove items from the start menu?