Interested to Buy Any Domain ? << Click Here >> for more details...
i want count no of values in a column i.e
enam eempno phoneno
x 1 (98765,09887,096561,87964579,156678,678900876)
that means if i select phone no from table i want to get
total count of phone numbers i.e 6
- 8 Answers
- 11344 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / venkat
select count(column_name) from table_name;
if u want to count number of phone numbers then use below
from emp table
select count(phno) from emp;
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is difference between stored function and application function?
What is information schema in sql?
what are date and time data types? : Sql dba
How to start the command-line sql*plus?
What is a trigger word?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Which sorts rows in sql?
What are types of indexes in sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Is sqlite good enough for production?
How to add, remove, modify users using sql?
Is primary key an index?
Why is a primary key important?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Is left join inner or outer?
