discuss about myisam index statistics collection. : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.
What are string functions in sql?
Can we use two order by clause in query?
What is audit logout in sql profiler?
Can a varchar be a primary key?
Is left join faster than inner join?
how to fetch alternate records from a table? : Sql dba
How do I view tables in mysql?
Is microsoft sql free?
Is ms sql is free?
suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.
7 Answers Geometric Software, IBM,
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