Jun 09 2008 11:22 AM 41766 44 Rename a Column vimalkumarrai How to rename a column in a SQL table? Read Best Answer Editorial / Best Answer sravee123 Profile Answers by sravee123 Questions by sravee123 Member Since May-2008 | Jun 10th, 2008 ALTER TABLE table_name RENAME COLUMN old_name to new_name;Ex: ALTER TABLE employee RENAME COLUMN eno to empno; srikanth.cherukupalli Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli Jan 12th, 2012 CodeALTER TABLE emp RENAME COLUMN emp_id TO id; karthickrfwin Profile Answers by karthickrfwin Questions by karthickrfwin Sep 22nd, 2011 Use this Script for nename particular ColumnName in SqlTable sp_rename 'TableName.[ColumnNameOld]','[ColumnNameNew]','Column' Improve Answer Mar 18 2006 02:17 PM 32283 166 What is the Querry for retrieving the 2nd highest salary in a table? suman Read Best Answer Editorial / Best Answer muralir02 Profile Answers by muralir02 Questions by muralir02 Member Since Mar-2006 | Mar 20th, 2006 select max(sal) from emp where sal<(select max(sal) from emp); sampra Profile Answers by sampra Questions by sampra Mar 6th, 2012 Select salry from Hello h where 2=(select count (distinct salry) from hello where h.salry srivathson Feb 20th, 2012 CodeSELECT max(Salary) WHERE salary<Select max(Salary) FROM employees Improve Answer Jul 16 2005 06:54 PM 6526 17 What is the difference between 8087 and 8086? SATYAM PAPER II 2004 karthickrfwin Profile Answers by karthickrfwin Questions by karthickrfwin Sep 10th, 2009 Both are 16bit microprocessors.8086 - belongs to x86 Architecture; - act as Main CPU of computer 8087 - belongs to x87 Architecture;- couldn't act as main CPU; Performs floating point mathametical computations. RAMANJANEYULU GURRAM Profile Answers by RAMANJANEYULU GURRAM Questions by RAMANJANEYULU GURRAM Jan 5th, 2008 8087 has more features than 8086 Answer Question Select Best Answer
Jun 09 2008 11:22 AM 41766 44 Rename a Column vimalkumarrai How to rename a column in a SQL table? Read Best Answer Editorial / Best Answer sravee123 Profile Answers by sravee123 Questions by sravee123 Member Since May-2008 | Jun 10th, 2008 ALTER TABLE table_name RENAME COLUMN old_name to new_name;Ex: ALTER TABLE employee RENAME COLUMN eno to empno; srikanth.cherukupalli Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli Jan 12th, 2012 CodeALTER TABLE emp RENAME COLUMN emp_id TO id; karthickrfwin Profile Answers by karthickrfwin Questions by karthickrfwin Sep 22nd, 2011 Use this Script for nename particular ColumnName in SqlTable sp_rename 'TableName.[ColumnNameOld]','[ColumnNameNew]','Column' Improve Answer
srikanth.cherukupalli Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli Jan 12th, 2012 CodeALTER TABLE emp RENAME COLUMN emp_id TO id;
karthickrfwin Profile Answers by karthickrfwin Questions by karthickrfwin Sep 22nd, 2011 Use this Script for nename particular ColumnName in SqlTable sp_rename 'TableName.[ColumnNameOld]','[ColumnNameNew]','Column'
Mar 18 2006 02:17 PM 32283 166 What is the Querry for retrieving the 2nd highest salary in a table? suman Read Best Answer Editorial / Best Answer muralir02 Profile Answers by muralir02 Questions by muralir02 Member Since Mar-2006 | Mar 20th, 2006 select max(sal) from emp where sal<(select max(sal) from emp); sampra Profile Answers by sampra Questions by sampra Mar 6th, 2012 Select salry from Hello h where 2=(select count (distinct salry) from hello where h.salry srivathson Feb 20th, 2012 CodeSELECT max(Salary) WHERE salary<Select max(Salary) FROM employees Improve Answer
sampra Profile Answers by sampra Questions by sampra Mar 6th, 2012 Select salry from Hello h where 2=(select count (distinct salry) from hello where h.salry
Jul 16 2005 06:54 PM 6526 17 What is the difference between 8087 and 8086? SATYAM PAPER II 2004 karthickrfwin Profile Answers by karthickrfwin Questions by karthickrfwin Sep 10th, 2009 Both are 16bit microprocessors.8086 - belongs to x86 Architecture; - act as Main CPU of computer 8087 - belongs to x87 Architecture;- couldn't act as main CPU; Performs floating point mathametical computations. RAMANJANEYULU GURRAM Profile Answers by RAMANJANEYULU GURRAM Questions by RAMANJANEYULU GURRAM Jan 5th, 2008 8087 has more features than 8086 Answer Question Select Best Answer
karthickrfwin Profile Answers by karthickrfwin Questions by karthickrfwin Sep 10th, 2009 Both are 16bit microprocessors.8086 - belongs to x86 Architecture; - act as Main CPU of computer 8087 - belongs to x87 Architecture;- couldn't act as main CPU; Performs floating point mathametical computations.
RAMANJANEYULU GURRAM Profile Answers by RAMANJANEYULU GURRAM Questions by RAMANJANEYULU GURRAM Jan 5th, 2008 8087 has more features than 8086