Why do we use alias for the table name? What is its importance?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 3rd, 2010

Alias is a alternate name given to a table for multiple purposes.The scope of the Alias is within the queryAlias is used to give short name to the table.Used when same table is used n number of times in a query. Alias is used in such queries to give unique name to each table reference. 

goksn

 Profile Answers by goksn Questions by goksn

• Sep 23rd, 2009

-is a shorthand notation-Will be used along with column name if same colum name present in more than one table (while joining those tables)-Must in self join

Answer Question  Select Best Answer

Write an SQL query if you want to select the data from one block which intern reflects in another block?

rshanmugaraj84

 Profile Answers by rshanmugaraj84 Questions by rshanmugaraj84

• Mar 5th, 2009

Select *from(Select *from ) a

Answer Question  Select Best Answer

What is the difference between interoperability and compatibility testing with some examples?

kurtz182

 Profile Answers by kurtz182 Questions by kurtz182

• Dec 19th, 2009

Compatibility testing verifies how a system under test behaves within a particular environment.  For example, a tremendous amount of research has been devoted toward understanding ...

srikich

 Profile Answers by srikich Questions by srikich

• Aug 1st, 2008

Interoperatability:-To check if the software can co exist with other supporting softwares in the systemCompatibility:-To check if the software runs on different types of operating systems according to customer requirements.

Answer Question  Select Best Answer