ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Query to select record based on age and qualification in SQL Server<p>Hi <a class="username" rel="itsme"> itsme</a>,</p> <p>Refer below query.</p> <p><span style="text-decoration: underline;"><strong>SQL</strong></span></p> <pre class="brush: sql">SELECT * FROM Post_job_details WHERE Qualification IN (select Qualification from Job_Seeker_Profile) OR Age IN (Select JS_age from Job_Seeker_Profile)</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/500256/Query-to-select-record-based-on-age-and-qualification-in-SQL-Server/https://www.aspforums.net:443/Threads/500256/Query-to-select-record-based-on-age-and-qualification-in-SQL-Server/Wed, 21 Aug 2019 05:13:23 GMTQuery to select record based on age and qualification in SQL Server<p>Thanks</p> <p>I also found one answer :</p> <pre class="brush: csharp">protected void Page_Load(object sender, EventArgs e) { string constr = ConfigurationManager.ConnectionStrings[&#34;Q_SS_regnConnectionString1&#34;].ConnectionString; SqlConnection con = new SqlConnection(constr); string query = &#34;SELECT Job_title,Company_name,Salary,Location,City,Qualification,Age FROM Post_job_details WHERE Qualification IN (select Qualification from Job_Seeker_Profile) OR Age In (Select JS_age from Job_Seeker_Profile) and email=&#39;&#34; + Session[&#34;mail&#34;].ToString() + &#34;&#39;&#34;; SqlCommand cmd = new SqlCommand(query,con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); GridView2.DataSource = dt; GridView2.DataBind(); }</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/500256/Query-to-select-record-based-on-age-and-qualification-in-SQL-Server/https://www.aspforums.net:443/Threads/500256/Query-to-select-record-based-on-age-and-qualification-in-SQL-Server/Wed, 21 Aug 2019 22:50:23 GMT