Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Q2
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
--PostgreSQL 9.6 --'\\' is a delimiter CREATE TABLE Course (SID INTEGER NOT NULL, ClassName CHAR(30) NOT NULL, Grade CHAR(1) NOT NULL) ; INSERT INTO Course(SID,ClassName,Grade) VALUES (123,'ART123','A'), (123,'BUS456','B'), (666,'REL100','D'), (666,'ECO966','A'), (666,'BUS456','B'), (345,'BUS456','A'), (345,'ECO966','F') ; SELECT * FROM Course; SELECT ClassName, count(*) from Course GROUP BY ClassName Order by Count(*) ASC;
absolute service time: 0,67 sec
fork mode
|
history
|
discussion
roomnum
arrdate
depdate
guestname
1
123
02.02.2016 00:00:00
06.02.2016 00:00:00
A
2
123
04.02.2016 00:00:00
08.02.2016 00:00:00
B
3
201
10.02.2016 00:00:00
06.02.2016 00:00:00
C