How to change rows to columns and columns into rows?

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

create table #temptable(rowid int,colorname varchar(25),Hexa varchar(7),R tinyint,G tinyint,B tinyint) GO insert into #temptable values(1,'Violet','#8B00FF',139,0,255); insert into #te...

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 21st, 2008

Use decode function.

Answer Question  Select Best Answer

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 18th, 2011

When you have to delete the records on primary key and foreigh key then there is problem will hapen as primary key violation at that time you have to provide delete rules when you create the tablesthose are1. on delete no action2. on delete cascade3. on delete set null4. on delete set default

caveatashish

 Profile Answers by caveatashish Questions by caveatashish

• Dec 14th, 2007

For primary key if that record is being refered by some other (Child Table)  sql server won't let you to delete that record.While creating relationship if you had mention "Dele...

Answer Question  Select Best Answer

It's working in MySQL but not in SQL-Server.

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 18th, 2011

  For deleting the records from the relational tables there are 4 options available. These options can be used when you create the tables then you have to use these options and create tables and ...

caveatashish

 Profile Answers by caveatashish Questions by caveatashish

• Dec 14th, 2007

Use a procedure which will delete record from child table first and then it will delete the same record from parent tableSame thing can be achieved using cascade delete and cascade update, this feature was not there in sql server 7.0

Answer Question  Select Best Answer

Write a query to find the list of employees whos age is greater than 30 or so given a date of birth column

Shailesh Bhilare

• Dec 6th, 2021

There is a table employee (empid,empname,DOB). Get the emp count against the age bracket of less than or equal to 30 and above 30.

Could you pls give the oracle syntax for tge above Query..?

Piyush Kumar

• May 4th, 2019

Curdate() will give you the current date. here we are subtracting from dob to current date(year).

Code
SELECT * FROM USER WHERE (YEAR(CURDATE()) - YEAR(DOB))>30;

Answer Question  Select Best Answer

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

   No, It's not possible because select statement only selects the values.   Thanks & Regards    K.Santhosh

RK

• Apr 24th, 2006

FOR EXAMPLE TO RETRIEVE 2ND COLUMN(ENAME)  IN EMP TABLE:SELECT COLUMN_NAME FROM USER_TAB_COLUMNSWHERE TABLE_NAME ='EMP'AND COLUMN_ID = 2

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Create table emp as select * from student where 1=2;

Satish Kopalle

 Profile Answers by Satish Kopalle Questions by Satish Kopalle

• Jun 7th, 2011

select * from faculty where rownum=0;

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Praveena

• Dec 14th, 2005

---

Yes we can alter Column name in a table using the following query:

alter table <tablename> rename column <old Column Name> to <New Column Name>

Regards,

Praveena

 

 

dude_8550

 Profile Answers by dude_8550 Questions by dude_8550

• Jun 15th, 2011

U can change the column name and also column definition that is whether the data type and its size by the ALTER command.ALTER TABLE RENAME COLUMN <old column name> TO <new coumn name>;

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

   yes, it's possible to change the column name by using the following query in SQL server       SP_RENAME ' <TABLE_NAME.OLD_COLUMN_NAME> ' , ' NEW_COLUMN_NAME '   Thanks & Regards    K.Santhosh

Improve Answer

HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

Mushtaque

• Aug 25th, 2013

WHERE clause can contains condition that must be met and should directly follow the from clause. And HAVING clause can precede GROUP BY clause,but it is more logical to declared in after GROUP BY clau...

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

   we have to apply the condition Before grouping the records then you have to use WHERE clause.   we have to apply the condition after grouping the records then you have to apply HAVING clause.  Thanks & Regards    K.Santhosh

Answer Question  Select Best Answer

Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though they don't satisfy the join condition.Equi-join--Its a join condition that retrieves rows from one or more tables in which one or more columns in one table are equal to one or more columns in the second table.

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

        There are 5 types of joins. Those  are   1. Equi Join /  Inner Join    2. Non-Equi Join   3. Outer Join ( Left Outer Join, Right Outer Join, Full Outer Join )   4. Self Join   5. Cross Join

thirupathireddy

 Profile Answers by thirupathireddy Questions by thirupathireddy

• Feb 2nd, 2010

Two join conidtion we can use for subqueries: Equi Join,Self Join

Answer Question  Select Best Answer