hafiz rafaqat

• Jun 1st, 2014

What is the difference bw time stamp and subtype discriminator?

gakorde

 Profile Answers by gakorde Questions by gakorde

• Oct 5th, 2010

Weak Entity is entity dependeant on other entity.Subtypes are data types inherited from basic data types in Oracle. we can specify additional constraint on subtype while defining them.

Answer Question  Select Best Answer

Select salary from tablename order by desc limt 4;

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Suppose we have to find records in the emp_salary table with nth highest value for salary.select * from emp_salary whare salary in(select distinct salary from emp_salary order by salary desc limit n-1,1);

Siva Krishna Yarlagadda

 Profile Answers by Siva Krishna Yarlagadda Questions by Siva Krishna Yarlagadda

• Apr 3rd, 2011

Select salary form employee order by salary desc limit 1,13rd Highest Salary-->Change Limit 2,14th highest salary-->change Limit 3,1

Answer Question  Select Best Answer

Is it required to use Index when the MySQL table has only 100 rows? Justify your answer

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Hi,Index is used to speed up query.If particular column is used often in queries and table has lot of data.Then it is recommended to create index for that column of the table. It will speed up the que...

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Index is a database structure which stores column value in order and pointer to the row containing this value.During query execution index is used to fast search column data used in where condition. I...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Lakum

• Aug 26th, 2007

---

This is an open source .. No licensing cost to pay. This itself is big thing even there are not many features like Oracle RAC, But you can manage all that with multiple servers and load balancing features. Provides Gui with Command Prompt. Supports the administration using MySQL Admin,MySQL Query Browser. Latest version supports stored procedures and functions. The best things is runs in windows and Unix/Linux.

Lakum

• Aug 26th, 2007

This is an open source .. No licensing cost to pay. This itself is big thing even there are not many features like Oracle RAC, But you can manage all that with multiple servers and load balancing feat...

kishor ranga

• Jul 22nd, 2006

MySql has many advantages in comparison to Oracle.1 - MySql is Open source, which can be available any time 2 - MySql has no cost of development purpose.3 - MySql has most of features , which oracle p...

Improve Answer