INSERT [dbo].[Seguros] ([seguro_folio], [vendedor_fk]) VALUES (314, 4)
 

SELECT * FROM (SELECT MAX(contador) AS maximo FROM 
(SELECT vendedor_fk, COUNT(vendedor_fk) contador
FROM dbo.Seguros GROUP BY vendedor_fk ) AS M
) AS M
INNER JOIN
(SELECT COUNT(*) AS ventas, vendedor_fk FROM dbo.Seguros
GROUP BY vendedor_fk) AS  T ON M.maximo=T.ventas
 

SELECT * FROM (
SELECT COUNT(*) AS ventas, vendedor_fk FROM dbo.Seguros GROUP BY vendedor_fk
) AS V WHERE V.ventas=(SELECT MAX(contador) AS maximo FROM 
(SELECT vendedor_fk, COUNT(vendedor_fk) contador
FROM dbo.Seguros GROUP BY vendedor_fk ) AS M)
 

/*Autor: 1mpuls0*/
 
public class NumberOfDivisors {
 
    public static void main(String args[]){
        long start = 0;
        long end = 0;
        int number = 420;
 
        start = System.nanoTime();
        System.out.println("Number of divisors " + number + ": " + countDivisors(number ));
        end = System.nanoTime();
        System.out.println("Execution time was " +(end-start)+" ns");
 
 
        start = System.nanoTime();
        System.out.println("Number of divisors " + number + ": " + countDivisors2(number ));
        end = System.nanoTime();
        System.out.println("Execution time was "+(end-start)+" ns");
 
    }
 
    public static int countDivisors(int number){
        int count = 0 ;
 
        for (int index = 1; index<=number; ++index){
            if (number%index==0){
                ++count;
            }
        }
        return count;
    }
 
    public static int countDivisors2(int number) {
        int index = 1;
        int count = 0 ;
 
        int div_2 = (int)Math.sqrt(number) + 1;
        while(index < div_2){
            if(number % index ==  0 ){
                count++;
            }
            index++;
        }
 
        if(count > 1){
            while(number >= index){
                if(number % index ==  0){
                    count++;
                }
                index++;
            }
        }
 
        return count;
    }
}
 

/**
 *
 * @author 1mpulso
 */
public class NewJFrame extends javax.swing.JFrame {
 
    /** Creates new form NewJFrame */
    public NewJFrame() {
        initComponents();
    }
 
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {
 
        jPanel1 = new javax.swing.JPanel();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jButton3 = new javax.swing.JButton();
        jPanel2 = new javax.swing.JPanel();
 
        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setMinimumSize(new java.awt.Dimension(500, 300));
        getContentPane().setLayout(new javax.swing.BoxLayout(getContentPane(), javax.swing.BoxLayout.LINE_AXIS));
 
        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("P. Izquierdo"));
        jPanel1.setLayout(new java.awt.GridLayout(5, 1, 5, 5));
 
        jButton1.setText("jButton1");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        jPanel1.add(jButton1);
 
        jButton2.setText("jButton2");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });
        jPanel1.add(jButton2);
 
        jButton3.setText("jButton3");
        jPanel1.add(jButton3);
 
        getContentPane().add(jPanel1);
 
        jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("P. Derecho"));
        getContentPane().add(jPanel2);
 
        pack();
    }// </editor-fold>//GEN-END:initComponents
 
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO add your handling code here:
    jPanel2.removeAll();
    NewJPanel p0 = new NewJPanel();
    jPanel2.add(p0);
    jPanel2.updateUI();
      jPanel2.repaint();
      repaint();
}//GEN-LAST:event_jButton1ActionPerformed
 
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
// TODO add your handling code here:
    jPanel2.removeAll();
    NewJPanel1 p1 = new NewJPanel1();
    jPanel2.add(p1);
    jPanel2.updateUI();
      jPanel2.repaint();
      repaint();
}//GEN-LAST:event_jButton2ActionPerformed
 
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(NewJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(NewJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(NewJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(NewJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>
 
        /* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
 
            public void run() {
                new NewJFrame().setVisible(true);
            }
        });
    }
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    // End of variables declaration//GEN-END:variables
}
 

/**
 *
 * @author 1mpuls0
 */
public class NewJPanel extends javax.swing.JPanel {
 
    /** Creates new form NewJPanel */
    public NewJPanel() {
        initComponents();
    }
 
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {
 
        jRadioButton1 = new javax.swing.JRadioButton();
        jCheckBox1 = new javax.swing.JCheckBox();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTextArea1 = new javax.swing.JTextArea();
 
        setBorder(javax.swing.BorderFactory.createTitledBorder("Panel0"));
 
        jRadioButton1.setText("jRadioButton1");
        add(jRadioButton1);
 
        jCheckBox1.setText("jCheckBox1");
        add(jCheckBox1);
 
        jTextArea1.setColumns(20);
        jTextArea1.setRows(5);
        jScrollPane1.setViewportView(jTextArea1);
 
        add(jScrollPane1);
    }// </editor-fold>//GEN-END:initComponents
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JCheckBox jCheckBox1;
    private javax.swing.JRadioButton jRadioButton1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextArea jTextArea1;
    // End of variables declaration//GEN-END:variables
}
 

/**
 *
 * @author 1mpuls0
 */
public class NewJPanel1 extends javax.swing.JPanel {
 
    /** Creates new form NewJPanel1 */
    public NewJPanel1() {
        initComponents();
    }
 
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {
 
        jButton1 = new javax.swing.JButton();
        jComboBox1 = new javax.swing.JComboBox();
        jTextField1 = new javax.swing.JTextField();
 
        setBorder(javax.swing.BorderFactory.createTitledBorder("Panel1"));
 
        jButton1.setText("jButton1");
        add(jButton1);
 
        jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        add(jComboBox1);
 
        jTextField1.setText("jTextField1");
        add(jTextField1);
    }// </editor-fold>//GEN-END:initComponents
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JComboBox jComboBox1;
    private javax.swing.JTextField jTextField1;
    // End of variables declaration//GEN-END:variables
}
 

 
 
/*Selecciona el total de las ventas por cada vendedor*/
SELECT COUNT(*) AS ventas FROM dbo.Seguros
GROUP BY vendedor_fk
 
/*Selecciona solo los primeros 2 ventas más grandes */
SELECT DISTINCT TOP(2) *
FROM ( SELECT COUNT(*) AS ventas FROM dbo.Seguros GROUP BY vendedor_fk) AS V
ORDER BY V.ventas DESC
 
/*Selecciona todos los vendedores y sus ventas*/
SELECT COUNT(*) AS ventas, vendedor_fk FROM dbo.Seguros
GROUP BY vendedor_fk
 
/*Se utiliza un Inner Join para unir las consultas que contiene las cantidades más grandes de ventas y el total de vendedores (con su total de ventas)*/