Example #1
0
 public static DataTable top10MasArrendadas()
 {
     Datos datos = new Datos();
     String sql = "SELECT TOP 10\n"
                 + " MIN(CAST(p.nombre as VARCHAR(max))) 'Pelicula'\n"
                 + ", MIN(CAST(p.codigo as VARCHAR(max))) 'Codigo'\n"
                 + ", Count(*) AS 'Arriendos'\n"
                 + ", MIN(CAST(p.genero as VARCHAR(max))) 'Genero'\n"
                 + ", MIN(CAST(p.formato as VARCHAR(max))) 'Formato'\n"
                 + " FROM arriendo AS a\n"
                 + " INNER JOIN pelicula AS p ON p.codigo=a.codigo\n"
                 + " GROUP BY a.codigo ORDER BY 'Arriendos' DESC, 'Pelicula';\n";
     DataTable dataTable = new DataTable();
     dataTable = datos.consultaSQL(sql);
     return dataTable;
 }
Example #2
0
 public static DataTable top10Clientes()
 {
     Datos datos = new Datos();
     String sql = "SELECT  TOP 10\n"
                 + "	c.run 'RUN'\n"
                 + "	, MIN(CAST(c.nombre as VARCHAR(max))) 'Nombre'\n"
                 + "	, MIN(CAST(c.apellido as VARCHAR(max))) 'Apellido'\n"
                 + "	, p.formato 'Formato'\n"
                 + "	, SUM(a.valorArriendo) AS 'Dinero en Arriendos'\n"
                 + "FROM arriendo AS a \n"
                 + "INNER JOIN cliente AS c ON c.run=a.run \n"
                 + "INNER JOIN pelicula AS p ON p.codigo=a.codigo \n"
                 + "GROUP BY c.run, p.formato ORDER BY 'Dinero en Arriendos' DESC, 'Apellido', 'Nombre';\n";
     DataTable dataTable = new DataTable();
     dataTable = datos.consultaSQL(sql);
     return dataTable;
 }