How write a SQL statement to query the result set and display row as columns and columns as row?

  • Interview Candidate
  • 7
  • 5725

Showing Answers 1 - 7 of 7 Answers

sarika

  • May 8th, 2006
 

How write a SQL statement to query the result set ...

  Was this answer useful?  Yes

Ilyas

  • Jul 24th, 2006
 

TRANSFORM Count(Roll_no) AS CountOfRoll_no
SELECT Academic_Status
FROM tbl_enr_status
GROUP BY Academic_Status
PIVOT Curnt_status;

  Was this answer useful?  Yes

Vasanth Kumar

  • Oct 6th, 2006
 

The simplest way to implement this in SQL 2000/OracleSelect * from table1Create a temp table with No of columns = No of rows in table 1No of rows = No of columns in table 1and insert the data into the temp table using a loop logic.

  Was this answer useful?  Yes

ratnam

  • Aug 3rd, 2012
 

How write a SQL statement to query the result set and display row as columns and columns as row?

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions