SQL Interview Questions and answers Part 12 | SQL Scenario based Interview Question and Answer

SQL Interview Questions and answers Part 12 | SQL Scenario based Interview Question and Answer Input :- Transaction_Table has four columns namely AccountNumber, TransactionTime, TransactionID and Balance Problem Statements :- Write SQL to get the most recent / latest balance, and TransactionID for each AccountNumber ------------------------------------------------------------------------- 𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥 ------------------------------------------------------------------------- 🔴 Instagram : https://www.instagram.com/itjunction4all/ 🔴 Twitter: https://twitter.com/sunilkr5672 ------------------------------------------------------------------------- 🔴 Table and Insert SQL Script : ------------------------------------------------------------------------- Create Table Transaction_Table ( AccountNumber int, TransactionTime DateTime, TransactionID int, Balance int ) Insert into Transaction_Table Values (550,'2020-05-12 05:29:44.120' ,1001,2000) Insert into Transaction_Table Values (550,'2020-05-15 10:29:25.630' ,1002,8000) Insert into Transaction_Table Values (460,'2020-03-15 11:29:23.620' ,1003,9000) Insert into Transaction_Table Values (460,'2020-04-30 11:29:57.320' ,1004,7000) Insert into Transaction_Table Values (460,'2020-04-30 12:32:44.233' ,1005,5000) Insert into Transaction_Table Values (640,'2020-02-18 06:29:34.420' ,1006,5000) Insert into Transaction_Table Values (640,'2020-02-18 06:29:37.120' ,1007,9000) #SQLInterviewQuestionsandanswers #sqlInterviewQuestions #sqlInterviewQuestionsForTesting #sql InterviewQuestionsQuery #sqlInterviewQuestionsOnJoins #RealtimeSqlQuestions