MCQs > IT & Programming > SQL >

Which of the following is the correct syntax for writing sub query?


SQL MCQs

Which of the following is the correct syntax for writing sub query?


Answer

Correct Answer:

SELECT sub.*

      FROM (

            SELECT *

              FROM abc

             WHERE day = 'Friday'

           ) sub

     WHERE sub.resolution = 'NONE'

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

SQL Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it