codersrank.io Sitesinin İlk 10 Rakibi

scientyficworld.org

This Cookie Policy explains how __________ ("Company," "we," "us," and "our") uses cookies and similar technologies to recognize you when you visit our

aliencoders.org

Hello Friends,  Have you ever been in a situation where you as a developer knows that your data is stored in your table rows, but you would like to present the data as a column ?? There are many way to handle this situation. Here I am sharing few of them which I know.​ Below is the sample table and data : ------------------------------------------------------------ [sql]CREATE TABLE yr_table (         Roll_No            NUMBER,         Subject            VARCHAR2(20),         Marks              NUMBER ); [/sql] [sql]insert into yr_table VALUES (1212324,'MTH',90); insert into yr_table VALUES (1212324,'PHY',72); insert into yr_table VALUES (1212324,'CHE',85); insert into yr_table VALUES (1212324,'BIO',78); insert into yr_table VALUES (1212334,'MTH',85); insert into yr_table VALUES (1212334,'PHY',65); insert into yr_table VALUES (1212334,'CHE',74); insert into yr_table VALUES (1212672,'MTH',88); insert into yr_table VALUES (1212672,'PHY',42); insert into yr_table VALUES (1212672,'BIO',12); COMMIT; [/sql] ------------------------------------------------------------------- Now I would like to represent above data into below format : We can achieve above output  in different way. # Method 1 ->  Using DECODE  function [sql]SELECT  ROLL_NO,                  MAX( DECODE( SUBJECT , 'MTH' , MARKS ) ) AS MTH  ,                  MAX( DECODE( SUBJECT , 'PHY' , MARKS ) ) AS PHY ,                  MAX( DECODE( SUBJECT , 'CHE' , MARKS ) ) AS CHE ,                  MAX( DECODE( SUBJECT , 'BIO' ,  MARKS ) ) AS BIO FROM yr_table GROUP BY ROLL_NO ORDER BY 1  ;​ [/sql] To understand the above query, first see  the below output of above query without using MAX function then you can understand how above query works. # Method 2 -> Using CASE​ statement  [sql]SELECT    ROLL_NO,                 MAX( CASE WHEN SUBJECT = 'MTH' THEN MARKS END) MTH ,                 MAX( CASE WHEN SUBJECT = 'PHY' THEN MARKS END) PHY ,                 MAX( CASE WHEN SUBJECT = 'CHE' THEN MARKS END) CHE ,          

educationecosystem.com

On the Education Ecosystem blog, we'll share stories about programming languages, skills and updates from coding industry, picked by our staff and broadcasters.

stopstalk.com

a tool to analyse and improve your competitive programming progress

see-programming.blogspot.com

A blog about programming languages

myprogrammingschool.com

The following statements describe privacy practices for My Programming School:

codecondo.com

Investing in India is no longer just about long-term wealth creation. Many people are looking for ways to grow their money over a few months to a few years. Short-term investments offer a smart way to meet immediate financial goals, such as building an emergency fund, saving for a vacation, or paying tuition fees. By choosing the right investment, you can earn reasonable returns without taking excessive risks.

exadel.com

Looking for an innovative way of making business? Learn more about the role and impact of cloud computing in digital transformation.

dailycupoftech.com

Daily Cup of Tech brings you the latest on startups, development, Martech, SaaS and tech products.

bridge-global.com

Bridge Global is a custom software development company United states, Canada and globally. As a global IT services company we offer software solutions.