WorkDO
  • Home
  • Career Advice
  • Job Seeker
  • Resume
  • Interview Preparation
  • Videos
No Result
View All Result
  • Home
  • Career Advice
  • Job Seeker
  • Resume
  • Interview Preparation
  • Videos
No Result
View All Result
WorkDO
No Result
View All Result
Home Videos

Accenture SQL Interview Questions | SQL Interview Preparation | Previous not null value |

Editor by Editor
September 25, 2021
in Videos
0
0
SHARES
14
VIEWS
Share on FacebookShare on Twitter



TCS interview questions and solutions:

Find Us On YouTube- “Subscribe Channel to watch Database related videos” https://www.youtube.com/channel/UCZA_5vGtSpZu86VBDdSnSag

For SQL Quiz-

Find Us On FaceBook-
https://www.facebook.com/SS-Unitech-187705388674384/

IF EXISTS(SELECT 1 FROM SYS.tables WHERE NAME=’prev_null_val’)
BEGIN
DROP TABLE prev_null_val
END

CREATE TABLE prev_null_val
(
SEQ INT,
ID INT,
NAME VARCHAR(50)
)

INSERT INTO prev_null_val VALUES (1,10,’A’),(2,NULL,’B’),(3,20,’C’),(4,null,’D’),(5,NULL,’E’),(6,30,’F’)

;WITH CTE AS
(
SELECT SEQ,ID,NAME,SUM(CASE WHEN ID IS NULL THEN 0 ELSE 1 END) OVER (ORDER BY SEQ) AS VAL_P
FROM prev_null_val
)
SELECT SEQ,ID,NAME,FIRST_VALUE(ID) OVER (PARTITION BY VAL_P ORDER BY SEQ) AS NEW_ID
FROM CTE

source

Tags: Accenturehow to prepare for interviewHOW TO PREPARE FOR TCS INTERVIEWimportant sql queries asked in interviewInfosysinterview preparationoptumsqlsql answerssql faqsql interviewsql interview questions for experiencedsql query interview questionssql questionssql questions for fresherssql tutorialtcstcs interviewtcs interview questionsTCS OFF CAMPUSTCS RECRUITMENTtop sql interview questionstricky sql queries for interview
Editor

Editor

Related Posts

Tell me about yourself job Interview Conversation || English Subtitles ||
Videos

Tell me about yourself job Interview Conversation || English Subtitles ||

September 26, 2023
How 'Bolt' is a Critique of Disney
Videos

How 'Bolt' is a Critique of Disney

September 26, 2023
Best Freelance Websites to Make Money Online in 2022
Videos

Best Freelance Websites to Make Money Online in 2022

September 26, 2023
Next Post
How To Use Keywords on LinkedIn to Find #Jobs | Jobseeker Tips!

How To Use Keywords on LinkedIn to Find #Jobs | Jobseeker Tips!

TOP 5 JOB PORTAL WEBSITES | LINKEDIN | CAREER WEBSITES| NAUKRI.COM |HOW TO APPLY | JOB VACANCY |JOBS

TOP 5 JOB PORTAL WEBSITES | LINKEDIN | CAREER WEBSITES| NAUKRI.COM |HOW TO APPLY | JOB VACANCY |JOBS

Top 10 Job searching websites in UAE | Jobs in UAE | How to search job in Middle East countries

Top 10 Job searching websites in UAE | Jobs in UAE | How to search job in Middle East countries

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

No Result
View All Result

Trending

Tell me about yourself job Interview Conversation || English Subtitles ||
Videos

Tell me about yourself job Interview Conversation || English Subtitles ||

by Editor
September 26, 2023
0

Tell me about yourself English Speaking Conversation || English Subtitles || For any queries or to make...

How 'Bolt' is a Critique of Disney

How 'Bolt' is a Critique of Disney

September 26, 2023
Best Freelance Websites to Make Money Online in 2022

Best Freelance Websites to Make Money Online in 2022

September 26, 2023
How to Start a Food Blog and Make Extra Income – Career Sidekick

How to Start a Food Blog and Make Extra Income – Career Sidekick

September 26, 2023
How to Become a Bartender and Make Extra Income – Career Sidekick

How to Become a Bartender and Make Extra Income – Career Sidekick

September 26, 2023

Highlights

How to Start a Food Blog and Make Extra Income – Career Sidekick

How to Become a Bartender and Make Extra Income – Career Sidekick

Top 15 Govt Job Vacancies in May 2023 | Employment News – Your Guide to the Job Opportunities

When Barack Obama was asked to share his most important career advice for young people, he replied

Resume Writing Tips and Tricks

Job Interview Conversation in English | Job Interview Question and Answer in English | CHIT CHAT

WorkDO

workdo.com will be hub of world wide information about jobs, employment , and consulting. Anything to assist in helping people seeking employment.

Connect with us

Categories

  • Career Advice
  • Interview Preparation
  • Job Seeker
  • Resume
  • Videos

Subscribe our Newsletter

[email-subscribers-form id=”1″]

  • Home
  • Contact
  • Privacy Policy
  • Disclaimer
  • Terms and Conditions

© 2021 All rights reserved

No Result
View All Result
  • Home
  • Career Advice
  • Job Seeker
  • Resume
  • Interview Preparation
  • Videos

© 2021 All rights reserved