dynamic pivot in sql | sql server interview question and answer part 23

preview_player
Показать описание

For Quiz-

Find Us On FaceBook-
  1. SS UNITECH
  2. sql server pivot multiple columns
  3. sql server pivot without aggregate
  4. sql server pivot dynamic columns
  5. sql server pivot rows to columns
  6. sql pivot tutorial
Рекомендации по теме
Dynamically Pivot Data 0:13:50

Dynamically Pivot Data in SQL Server

Dynamic Pivot function 0:15:12

Dynamic Pivot function in sql server | sql dynamic pivot data

SQL Tutorial - 0:19:40

SQL Tutorial - How to create a Dynamic Pivot in SQL Part 1

SQL Server Programming 0:13:08

SQL Server Programming Part 18 - Dynamic Pivot Tables

SQL Query | 0:16:18

SQL Query | How to dynamically convert rows into columns | Dynamic Pivot

SQL Dynamic Pivot 0:06:13

SQL Dynamic Pivot Explained SIMPLY | with Syntax & Use Cases

TSQL: How To 0:04:40

TSQL: How To Build A Dynamic Pivot Table

SQL Server Dynamic 0:03:21

SQL Server Dynamic Pivot

dynamic pivot in 0:13:07

dynamic pivot in sql | sql server interview question and answer part 23

SQL Tutorial - 0:11:16

SQL Tutorial - How to create a Dynamic Pivot in SQL Part 2

Dynamic Pivot Column 0:04:04

Dynamic Pivot Column Data in SQL Server | Rows convert to column in SQL Server

Building Dynamic Pivot 0:59:22

Building Dynamic Pivot Tables using SQL Server. | Essential SQL

SQL Server - 0:09:39

SQL Server - Dynamic Pivot Tables

Dynamic Column SQL 0:16:03

Dynamic Column SQL PIVOT Query | SQL PIVOT Query

Dynamic Pivot Columns 0:08:12

Dynamic Pivot Columns | How to generate dynamic Pivot Columns in BigQuery

Dynamic pivot in 0:04:48

Dynamic pivot in SQL example

How to Create 0:01:31

How to Create a Dynamic Pivot Table in MySQL

T-SQL Tutorial. Dynamic 0:08:54

T-SQL Tutorial. Dynamic SQL course: Dynamic Pivot and Unpivot (Lesson 3)

Dynamic Pivot Tables 0:06:50

Dynamic Pivot Tables in SQL Server

SQL : MySQL 0:01:12

SQL : MySQL dynamic-pivot

SQL Magic: Dynamic 0:32:18

SQL Magic: Dynamic Pivot, Polymorphic Table Functions and More

SQL : Dynamic 0:01:16

SQL : Dynamic Pivot Table in SQL Server

SQL : Dynamic 0:01:19

SQL : Dynamic Pivot in Oracle's SQL

How to Create 0:02:07

How to Create a Multi Dynamic Pivot in SQL Server

Комментарии
Автор

create table Dynamicpivot_tbl
(
custid int,
name varchar(10),
mobilenum varchar(10),
calldate date,
starttime time,
Duration numeric(14, 2)
)

insert Dynamicpivot_tbl
select 1, 'SHIV', 'XXYYXXYZZA', '2018-03-20', '00:01:15', 1.5
UNION
select 1, 'SHIV', 'XXYYXXYZZA', '2018-03-21', '00:04:15', 2.5
UNION
select 1, 'SHIV', 'XXYYXXYZZA', '2018-03-21', '00:05:30', 2.6
UNION
select 1, 'SHIV', 'XXYYXXYZZA', '2018-03-22', '00:10:44', 7.9
UNION
select 2, 'SAKET', 'XXYYXXYZZB', '2018-03-20', '00:05:30', 10.5
UNION
select 2, 'SAKET', 'XXYYXXYZZB', '2018-03-20', '00:15:15', 2.0

SELECT * FROM Dynamicpivot_tbl

GaneshNaduvathati
Автор

using case statement in mysql:
SELECT custid, name, mobilenum
, SUM(CASE WHEN calldate = '2018-03-20' THEN Duration ELSE 0 END) '2018-03-20',
SUM(CASE WHEN calldate = '2018-03-21' THEN Duration ELSE 0 END) '2018-03-21',
SUM(CASE WHEN calldate = '2018-03-22' THEN Duration ELSE 0 END) '2018-03-22'
FROM dynamicpivot_tbl group by name

jesseantony
Автор

Nice one sir. It was very easy to understand.

pravaspatra
Автор

Nice video easy way to explanation...thanks

deepalakhera
Автор

How to use multiple column in pivot function

nihalkumar
Автор

I can't found scripts on Face book page.. could you please share the links

PrashantKumar-nhoy