select Reques_id ,LeaveFromdate ,LeaveTodate FROM LeaveTbl LT leto JOIN LeaveTbl_detail LTD on LT.Request_id = LTD.Request_id I a getting the result as 3 individual rows for 3 unique request Result: But i need to get a single row for continuous request like this Expected Re..
Tag : sql
I have the following piece ..
ou’ve been given a database for an online streaming service that first released in 2020. The database has a table customers with a column net_new that records net new monthly subscriptions to the streaming service broken down by tiers: free, standard, and pr..
How can I have a single record for case statement by grouping? If there is an other solution, please let me..
I need to write a stored procedure which takes response from API and save values in local DB.For example, I have a string like this “Image is Non-compliant nFace Covered nIncorrect Lighting n”. I need to extract the text between n character like Face Covered and Incorrect Lighting. How to write a sql query to extract the text and the string length may v..
I’m trying to create the following sql tables’ structure, but I can’t figure out the problem. Here’s an ex..
I’m trying to create the following sql tables’ structure, but I can’t figure out the problem. Here’s an ex..
I have a SQL server Table. I want the records look like the example below.
I want to retrieve the TrainType values in the same order they were inserted.
I am thinking to attach a sequence number column to guarantee the order of retrieval to match the order of i..
I need to create a view from the table by joining the columns from the same table.
Here is how my table has been c..
I have a SQL table similar to..