Welcome to the Webmaster Forum.
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
Like Tree1Likes

Thread: What is a SubQuery?

  1. #1
    Senior Member
    Join Date
    Jan 2014
    Location
    Banglore
    Posts
    289

    What is a SubQuery?

    • Subquery or Inner query or Nested query is a query in a query.

    • A Subquery is usually added in the WHERE Clause of the sql statement.

    • Used when we know how to search a value using SELECT statement, but don’t know the xact value.

    • Subqueries are an alternate way of returning data from multiple tables.

    • Subqueries can be used with the following sql statements along with the comparison operators like =, <, >, >=, <= etc. SELECT, INSERT, UPDATE, DELETE

  2. #2
    Senior Member
    Join Date
    May 2015
    Location
    Londan
    Posts
    118

    Re: What is a SubQuery?

    A Subquery or Inner query or Nested query is a query within another SQL query and embedded within the WHERE clause.

  3. #3
    Senior Member
    Join Date
    Dec 2016
    Location
    Canada
    Posts
    181

    Re: What is a SubQuery?

    Quote Originally Posted by chinmay.sahoo View Post
    • Subquery or Inner query or Nested query is a query in a query.

    • A Subquery is usually added in the WHERE Clause of the sql statement.

    • Used when we know how to search a value using SELECT statement, but don’t know the xact value.

    • Subqueries are an alternate way of returning data from multiple tables.

    • Subqueries can be used with the following sql statements along with the comparison operators like =, <, >, >=, <= etc. SELECT, INSERT, UPDATE, DELETE
    Good job, man.
    Keep sharing

  4. #4
    Member
    Join Date
    Mar 2016
    Location
    Canada
    Posts
    62

    Re: What is a SubQuery?

    Subquary is a query in a query. SQL subquery is usually added in the WHERE Clause of the SQL statement. Sub query is also known as inner query or nested query.

  5. #5
    Senior Member
    Join Date
    Aug 2014
    Location
    India
    Posts
    195

    Re: What is a SubQuery?

    A MySQL subquery is a query that is nested inside another query such as SELECT, INSERT, UPDATE or DELETE. In addition, a MySQL subquery can be nested inside another subquery.

  6. #6
    Senior Member
    Join Date
    Dec 2016
    Posts
    106

    Re: What is a SubQuery?

    thanks men

  7. #7
    Senior Member
    Join Date
    Dec 2016
    Posts
    106

    Re: What is a SubQuery?

    thanks men
    targetr review 3 easy steps to earned 10,000 $ in just 14 days and very extra bonus for you .

  8. #8
    Senior Member
    Join Date
    Aug 2016
    Location
    Kolkata
    Posts
    276

    Re: What is a SubQuery?

    Nice Info.
    Thanks for Sharing keep it up.

  9. #9
    Senior Member
    Join Date
    Dec 2016
    Posts
    283

    Re: What is a SubQuery?

    1 subquery is simply a SELECT statement within another one SELECT statement, with the aim of returning the results for external use SELECT statements. Subquery may lie in the SELECT clause, FROM (called inline view), WHERE or HAVING.

  10. #10
    Senior Member
    Join Date
    Jan 2016
    Posts
    212

    Re: What is a SubQuery?

    A Subquery or Inner question or Nested question is a question within another SQL question and included within the where stipulation.

  11. #11
    Senior Member
    Join Date
    Nov 2013
    Posts
    190

    Re: What is a SubQuery?

    Hi, Subquery is also named as Inner Query and Nested Query which is Query under a query. SQL subquery is usually added in the WHERE Clause of the SQL statement.

    Thanks!

    ____________
    static code analysis security

  12. #12
    Junior Member
    Join Date
    Feb 2018
    Location
    Hyderabad
    Posts
    23

    Re: What is a SubQuery?

    A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within the WHERE clause. A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved.

  13. #13
    Member
    Join Date
    Dec 2017
    Location
    Santa Clara, California, USA
    Posts
    81

    Re: What is a SubQuery?

    A subquery is a query embedded within the WHERE clause of another query to further restrict data returned by the query. It is a query within another query, also known as a nested query. It is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved. Subqueries are used with the SELECT, INSERT, UPDATE, and DELETE statements.

  14. #14
    Junior Member
    Join Date
    Feb 2018
    Posts
    16

    Re: What is a SubQuery?

    A subquery is a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another subquery. A subquery can be used anywhere an expression is allowed.A subquery is also called an inner query or inner select, while the statement containing a subquery is also called an outer query or outer select.

  15. #15
    Senior Member
    Join Date
    Jan 2018
    Posts
    488

    Re: What is a SubQuery?

    A Subquery or Inner query or Nested query is a query within another SQL query and embedded within the WHERE clause.

 

 
Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Back to top

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207