Interested to Buy Any Domain ? << Click Here >> for more details...
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 Answers
- 13623 Views
- Fidelity, IBM, I also Faced
- E-Mail Answers
Answer Posted / ramesh
Select count(id), accnt_type from Account
group by accnt_type;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Write a sql query to get the third highest salary of an employee from employee_table?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Define a temp table?
what is datawarehouse? : Sql dba
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
what is 'mysqlshow'? : Sql dba
which tcp/ip port does sql server run on? : Sql dba
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
Mention what pl/sql package consists of?
How do you use join?
What is pl sql quora?
How does an execution block start and end in pl sql?
What are the different types of functions in sql?
What are sql*plus environment variables?
