SQL Where Complex Query : #100daysofsql Day 3

 SELECT --43659, 43662
  SalesOrderId,
  SalesOrderNumber,
  SubTotal,
  OrderDate,
  (
    SELECT SUM(OrderQty)
    FROM Sales.SalesOrderDetail
    WHERE SalesOrderID not in (43659, 43661, 43662, 43668)
  ) AS TotalSales
FROM
  Sales.SalesOrderHeader
WHERE
  SalesOrderID not in (43659, 43661, 43662, 43668);

The above query explained in this below video,

Comments

Java Swing MySql JDBC: insert data into database

Program import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.*; public class insertswing implements ActionListener { JFrame fr;JPanel po; JLabel l1,l2,main; JTextField tf1,tf2; GridBagConstraints gbc; GridBagLayout go; JButton ok,exit; public insertswing(){ fr=new JFrame("New User Data "); Font f=new Font("Verdana",Font.BOLD,24); po=new JPanel(); fr.getContentPane().add(po); fr.setVisible(true); fr.setSize(1024,768); fr.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); po.setBackground(Color.WHITE); go=new GridBagLayout(); gbc=new GridBagConstraints(); po.setLayout(go); main=new JLabel("Enter User Details "); main.setFont(f); l1=new JLabel("Name :");tf1=new JTextField(20); l2=new JLabel("User Name :");tf2=new JTextField(20); ok=new JButton("Accept"); exit=new JButton("Exit"); gbc.anchor=GridBagConstraints.NORTH;gbc.gridx=5;gbc.gridy=0; go.s...

JSP and Servlet Form Submission without page refresh show results on the same page using Jquery AJAX

Code Snippet HTML Form <form id='ajaxform' name='ajaxform' action='ajaxformexample' method='post'> First Name: <input type='text' id='firstname' name='firstname' size='30' required/><br/> Last Name: <input type='text' id='lastname' name='lastname' size='30'required/><br/> Email: <input type='email' id='emailid' name='emailid' size='30'required/><br/> Password: <input type='password' id='pwd' name='pwd' size='30'required/><br/> <input type='Submit'/> <div id='content'> </div> </form> the above HTML Form uses post method and url servlet redirect to " ajaxformexample " Javascript Code var form = $('#ajaxform'); // id of form tag form.submit(function () { $.ajax({ ...

Guidewire Related Interview Question and answers part 1

common Guidewire questions and answers 20 Guidewire BC Q&A Top 100 Guidewire Interview FAQ Guidewire Claimcenter 20 Interview Questions Guidewire Rating concepts

Kumaran1987

Search This Blog