A

@AdnanTurjoy

2nd largest

C
3 years ago
#include<stdio.h> int main() { int a[100],n,i,k,j,max=0,secondMax; scanf("%d",&n); for ( i = 0; i < n; i++) { scanf("%d ",&a[i]); if(max<=a[i]){ secondMax=max;

fetch top N records / IMPORTANT

SQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null, joindate DATE ); -- create a department table create table department(

deatails about student for those student get commision greater than 12% - cloudIT 566 page

MySQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null, joindate DATE ); -- create a department table create table department(

deatails about student for those student get commision greater than 12%

MySQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null, joindate DATE ); -- create a department table create table department(

between

MySQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null, joindate DATE ); -- create a department table create table department(

<> not

MySQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null, joindate DATE ); -- create a department table create table department(

highest number of dept and its highest

MySQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null, joindate DATE ); -- create a department table create table department(

highest salary info who stay in specific address, multiple sub query

MySQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null, joindate DATE ); -- create a department table create table department(

show only deptid 1,2 and male person

MySQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null, joindate DATE ); -- create a department table create table department(

details of highest paid employee and highest salary of individual each dept and age calculate

MySQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null, joindate DATE ); -- create a department table create table department(

details of highest paid employee and highest salary of individual each dept

MySQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null, joindate DATE ); -- create a department table create table department(

details of highest paid employee

MySQL
3 years ago
CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null ); -- create a department table create table department( deptid INTEGER PRIMARY key,

Aggregate function

MySQL
3 years ago
-- create a student table CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null ); -- create a department table

JOIN

MySQL
3 years ago
-- create a students table CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null ); -- create a department table create table department(

avarage salary

MySQL
3 years ago
-- create a students table CREATE TABLE student ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null ); -- create a department table create table department(

MYSQL DEMO

MySQL
3 years ago
-- create a students table CREATE TABLE students ( sid INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL, deptid INTEGER NOT null, salary INTEGER NOT null ); -- create a department table create table department(

demo

MySQL
3 years ago
-- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name VARCHAR(30) NOT NULL, gender CHAR(1) NOT NULL ); -- insert some values INSERT INTO students VALUES (1, 'Ryan', 'M'),(2, 'Joanna', 'F'),(3, 'Joanna', 'F'),(4, 'Joanna', 'F'); -- fetch some values

2nd largest problem.. Ex Question

Java
3 years ago
import java.util.*; import java.lang.*; import java.io.*; // The main method must be in a class named "Main". class Main { public static void main(String[] args) { int a,b,c,n; Scanner s = new Scanner(System.in); System.out.println("Enter A: ");

BUET question

C
3 years ago
#include<stdlib.h> #include<stdio.h> #include<string.h> int main() { int i=0, length;

Heap Sort

C
3 years ago
// Heap Sort in C #include <stdio.h> void heapify(int a[], int n, int i) { int temp,root = i; int left = 2 * i + 1; int right = 2 * i + 2;