Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SALESPEOPLE
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
CREATE TABLE SALESPEOPLE( SNUM INT NOT NULL, SNAME VARCHAR (20) NOT NULL, CITY VARCHAR (25) , COMM DECIMAL (18, 2), ); INSERT INTO SALESPEOPLE VALUES (1001, 'peel', 'london', .12 ); INSERT INTO SALESPEOPLE VALUES (1002, 'serres','san jose', .13); INSERT INTO SALESPEOPLE VALUES (1004, 'motika', 'london', .11); INSERT INTO SALESPEOPLE VALUES (1007, 'rafkin', 'barcelona', .15); INSERT INTO SALESPEOPLE VALUES (1003, 'axelord', 'new york', .1); SELECT * from SALESPEOPLE
View schema
Execution time: 0,02 sec, rows selected: 5, rows affected: 5, absolute service time: 0,22 sec, absolute service time: 0,22 sec
edit mode
|
history
|
discussion
SNUM
SNAME
CITY
COMM
1
1001
peel
london
0,12
2
1002
serres
san jose
0,13
3
1004
motika
london
0,11
4
1007
rafkin
barcelona
0,15
5
1003
axelord
new york
0,10