SQL | Practice Complex SQL Queries | SQL Complex Queries

[@LearnatKnowstar]

Please post any SQL Queries you wished to get answered in the comments below! Thank you all for watching the session and sending your queries!

[@soumikmahajan6317]

Today I learn lots of awesome concepts, Thank You..

[@LearnatKnowstar]

Glad it was helpful!

[@RassiqueMukkarram]

Thank you for the effort, looking forward to my requested query

[@LearnatKnowstar]

Thank You. We will answer in the next session.

[@EternalEvanesce]

Thank you for making this! Very insightful.

[@LearnatKnowstar]

Glad it was helpful!

[@Nsk90-tg6pj]

Can uou explain how many weekend days in a month?

[@BillionDollerDream]

can we use like operator to find spaces? select * from Table where column like '% %'

[@ankithsharma1766]

Clarify difference between Null and Blank please

[@undergraduate6050]

Best books to study in-depth SQL server.

[@gamingwithlegend3183]

Dear sister you solved that question which i provide you but it's not dynamic I means it should be dependent on user whether he want two columns or 3 columns or 5 columns.

[@LearnatKnowstar]

You can pass dynamically number of columns in the variable we have used in the example. The number of columns is being dynamically passed to the final query.

[@Atul_7019]

Hi, I have questions, can you please give the solution for this. We have office data related punch in and punch out data. As a employee we used to go out from office multiple times for tea, snacks etc. We need to find out time duration of a employee in a working day , how much time he was out of office. Table Office: Columns: EmployeeId, starttimeofoffice, endtimeofoffice, punchIn, Punchout

[@LearnatKnowstar]

Thank you for sharing. We will answer in the next session.

[@sandeepagrawal3012]

Explain different date formats what we receive from source and what is default format we keep in sql server tables, how to handle different date formats using sql server convert function Also discuss this prblm

[@dineshbalu2038]

hi ma'am i have a query from my side i don't know how to solve this question can you please me out from this query. ' List the movies which were never rented out.'