Data for this record: SELECT * FROM Employees

Display with tables

EmployeeIDEmployeeNameCompanyIDDeptIDSalary
aceSharapova, MariaIBMHR3000
bluesGilmour, DavidAOLPROD150000
bugsGates, BillyAOLMKT190000
classicAgassi, AndreBLOFIN215000
doubtStefani, GwenINTPROD265000
eatalotRay, RachelIBMACCT215000
evanesceLee, AmyAOLMKT190000
festivusCostanza, GeorgeMSFFIN150000
fictionThurman, UmaBLOFIN140000
fleetwoodNicks, StevieDELPROD180000
freezeBauer, JackIBMFIN180000
getshortyBarboni, JoeHEIHR190000
hairKramer, CosmoINTMKT185000
imagineLennon, JuanINTMKT210000
jawsLeno, JayIBMSTR130000
jingoSantana, CarlosMSFPROD230000
juliaBenes, ElaineHEIACCT210000
kickHamm, MiaAOLSTR200000
kwackDuck, DonaldINTACCT175000
legendNavratilova, MartinaHEIMKT220000
likeprinceParker, CamilaBLOFIN145000
moneyTrump, DonnyAOLSTR200000
newsCouric, KatieAOLMKT175000
nynySinatra, FrankyINTACCT190000
powerWinfrey, OprahBLOFIN215000
preppyLauren, RafaelBLOPROD200000
pulpTravolta, JohnnyINTPROD170000
signeClapton, EricMSFFIN180000
slalomStreet, PicaboDELPROD180000
talldudeJohnson, MagicBLOSTR140000
taxidriverDe Niro, RobertINTFIN210000
timeStewart, MarthaIBMHR198000
toptenLetterman, DaveIBMACCT210000
travoltaVega, LucentBLOSTR255000
ukBlair, TonyIBMMKT180000
unionstKrauss, AlisonBLOFIN165000
vegasCrow, SherylINTFIN185000
viewWalters, BarbieIBMMKT235000
wavesHamilton, LairdBLOPROD200000
wreckBranch, MichelleDELACCT200000
xxxEspinosaDELFIN1000000
xxxxxharicehDELACCT22222
testOffsie, JoshIBMMKT64000
zeppelinPage, JimmyAOLSTR175000

Display in rows with field names

EmployeeID=ace; EmployeeName=Sharapova, Maria; CompanyID=IBM; DeptID=HR; Salary=3000;

EmployeeID=blues; EmployeeName=Gilmour, David; CompanyID=AOL; DeptID=PROD; Salary=150000;

EmployeeID=bugs; EmployeeName=Gates, Billy; CompanyID=AOL; DeptID=MKT; Salary=190000;

EmployeeID=classic; EmployeeName=Agassi, Andre; CompanyID=BLO; DeptID=FIN; Salary=215000;

EmployeeID=doubt; EmployeeName=Stefani, Gwen; CompanyID=INT; DeptID=PROD; Salary=265000;

EmployeeID=eatalot; EmployeeName=Ray, Rachel; CompanyID=IBM; DeptID=ACCT; Salary=215000;

EmployeeID=evanesce; EmployeeName=Lee, Amy; CompanyID=AOL; DeptID=MKT; Salary=190000;

EmployeeID=festivus; EmployeeName=Costanza, George; CompanyID=MSF; DeptID=FIN; Salary=150000;

EmployeeID=fiction; EmployeeName=Thurman, Uma; CompanyID=BLO; DeptID=FIN; Salary=140000;

EmployeeID=fleetwood; EmployeeName=Nicks, Stevie; CompanyID=DEL; DeptID=PROD; Salary=180000;

EmployeeID=freeze; EmployeeName=Bauer, Jack; CompanyID=IBM; DeptID=FIN; Salary=180000;

EmployeeID=getshorty; EmployeeName=Barboni, Joe; CompanyID=HEI; DeptID=HR; Salary=190000;

EmployeeID=hair; EmployeeName=Kramer, Cosmo; CompanyID=INT; DeptID=MKT; Salary=185000;

EmployeeID=imagine; EmployeeName=Lennon, Juan; CompanyID=INT; DeptID=MKT; Salary=210000;

EmployeeID=jaws; EmployeeName=Leno, Jay; CompanyID=IBM; DeptID=STR; Salary=130000;

EmployeeID=jingo; EmployeeName=Santana, Carlos; CompanyID=MSF; DeptID=PROD; Salary=230000;

EmployeeID=julia; EmployeeName=Benes, Elaine; CompanyID=HEI; DeptID=ACCT; Salary=210000;

EmployeeID=kick; EmployeeName=Hamm, Mia; CompanyID=AOL; DeptID=STR; Salary=200000;

EmployeeID=kwack; EmployeeName=Duck, Donald; CompanyID=INT; DeptID=ACCT; Salary=175000;

EmployeeID=legend; EmployeeName=Navratilova, Martina; CompanyID=HEI; DeptID=MKT; Salary=220000;

EmployeeID=likeprince; EmployeeName=Parker, Camila; CompanyID=BLO; DeptID=FIN; Salary=145000;

EmployeeID=money; EmployeeName=Trump, Donny; CompanyID=AOL; DeptID=STR; Salary=200000;

EmployeeID=news; EmployeeName=Couric, Katie; CompanyID=AOL; DeptID=MKT; Salary=175000;

EmployeeID=nyny; EmployeeName=Sinatra, Franky; CompanyID=INT; DeptID=ACCT; Salary=190000;

EmployeeID=power; EmployeeName=Winfrey, Oprah; CompanyID=BLO; DeptID=FIN; Salary=215000;

EmployeeID=preppy; EmployeeName=Lauren, Rafael; CompanyID=BLO; DeptID=PROD; Salary=200000;

EmployeeID=pulp; EmployeeName=Travolta, Johnny; CompanyID=INT; DeptID=PROD; Salary=170000;

EmployeeID=signe; EmployeeName=Clapton, Eric; CompanyID=MSF; DeptID=FIN; Salary=180000;

EmployeeID=slalom; EmployeeName=Street, Picabo; CompanyID=DEL; DeptID=PROD; Salary=180000;

EmployeeID=talldude; EmployeeName=Johnson, Magic; CompanyID=BLO; DeptID=STR; Salary=140000;

EmployeeID=taxidriver; EmployeeName=De Niro, Robert; CompanyID=INT; DeptID=FIN; Salary=210000;

EmployeeID=time; EmployeeName=Stewart, Martha; CompanyID=IBM; DeptID=HR; Salary=198000;

EmployeeID=topten; EmployeeName=Letterman, Dave; CompanyID=IBM; DeptID=ACCT; Salary=210000;

EmployeeID=travolta; EmployeeName=Vega, Lucent; CompanyID=BLO; DeptID=STR; Salary=255000;

EmployeeID=uk; EmployeeName=Blair, Tony; CompanyID=IBM; DeptID=MKT; Salary=180000;

EmployeeID=unionst; EmployeeName=Krauss, Alison; CompanyID=BLO; DeptID=FIN; Salary=165000;

EmployeeID=vegas; EmployeeName=Crow, Sheryl; CompanyID=INT; DeptID=FIN; Salary=185000;

EmployeeID=view; EmployeeName=Walters, Barbie; CompanyID=IBM; DeptID=MKT; Salary=235000;

EmployeeID=waves; EmployeeName=Hamilton, Laird; CompanyID=BLO; DeptID=PROD; Salary=200000;

EmployeeID=wreck; EmployeeName=Branch, Michelle; CompanyID=DEL; DeptID=ACCT; Salary=200000;

EmployeeID=xxx; EmployeeName=Espinosa; CompanyID=DEL; DeptID=FIN; Salary=1000000;

EmployeeID=xxxxx; EmployeeName=hariceh; CompanyID=DEL; DeptID=ACCT; Salary=22222;

EmployeeID=test; EmployeeName=Offsie, Josh; CompanyID=IBM; DeptID=MKT; Salary=64000;

EmployeeID=zeppelin; EmployeeName=Page, Jimmy; CompanyID=AOL; DeptID=STR; Salary=175000;

Display in rows, only data

ace; Sharapova, Maria; IBM; HR; 3000;

blues; Gilmour, David; AOL; PROD; 150000;

bugs; Gates, Billy; AOL; MKT; 190000;

classic; Agassi, Andre; BLO; FIN; 215000;

doubt; Stefani, Gwen; INT; PROD; 265000;

eatalot; Ray, Rachel; IBM; ACCT; 215000;

evanesce; Lee, Amy; AOL; MKT; 190000;

festivus; Costanza, George; MSF; FIN; 150000;

fiction; Thurman, Uma; BLO; FIN; 140000;

fleetwood; Nicks, Stevie; DEL; PROD; 180000;

freeze; Bauer, Jack; IBM; FIN; 180000;

getshorty; Barboni, Joe; HEI; HR; 190000;

hair; Kramer, Cosmo; INT; MKT; 185000;

imagine; Lennon, Juan; INT; MKT; 210000;

jaws; Leno, Jay; IBM; STR; 130000;

jingo; Santana, Carlos; MSF; PROD; 230000;

julia; Benes, Elaine; HEI; ACCT; 210000;

kick; Hamm, Mia; AOL; STR; 200000;

kwack; Duck, Donald; INT; ACCT; 175000;

legend; Navratilova, Martina; HEI; MKT; 220000;

likeprince; Parker, Camila; BLO; FIN; 145000;

money; Trump, Donny; AOL; STR; 200000;

news; Couric, Katie; AOL; MKT; 175000;

nyny; Sinatra, Franky; INT; ACCT; 190000;

power; Winfrey, Oprah; BLO; FIN; 215000;

preppy; Lauren, Rafael; BLO; PROD; 200000;

pulp; Travolta, Johnny; INT; PROD; 170000;

signe; Clapton, Eric; MSF; FIN; 180000;

slalom; Street, Picabo; DEL; PROD; 180000;

talldude; Johnson, Magic; BLO; STR; 140000;

taxidriver; De Niro, Robert; INT; FIN; 210000;

time; Stewart, Martha; IBM; HR; 198000;

topten; Letterman, Dave; IBM; ACCT; 210000;

travolta; Vega, Lucent; BLO; STR; 255000;

uk; Blair, Tony; IBM; MKT; 180000;

unionst; Krauss, Alison; BLO; FIN; 165000;

vegas; Crow, Sheryl; INT; FIN; 185000;

view; Walters, Barbie; IBM; MKT; 235000;

waves; Hamilton, Laird; BLO; PROD; 200000;

wreck; Branch, Michelle; DEL; ACCT; 200000;

xxx; Espinosa; DEL; FIN; 1000000;

xxxxx; hariceh; DEL; ACCT; 22222;

test; Offsie, Josh; IBM; MKT; 64000;

zeppelin; Page, Jimmy; AOL; STR; 175000;

Display in rows, only data, but using #include

ace; Sharapova, Maria; IBM; HR; 3000;

blues; Gilmour, David; AOL; PROD; 150000;

bugs; Gates, Billy; AOL; MKT; 190000;

classic; Agassi, Andre; BLO; FIN; 215000;

doubt; Stefani, Gwen; INT; PROD; 265000;

eatalot; Ray, Rachel; IBM; ACCT; 215000;

evanesce; Lee, Amy; AOL; MKT; 190000;

festivus; Costanza, George; MSF; FIN; 150000;

fiction; Thurman, Uma; BLO; FIN; 140000;

fleetwood; Nicks, Stevie; DEL; PROD; 180000;

freeze; Bauer, Jack; IBM; FIN; 180000;

getshorty; Barboni, Joe; HEI; HR; 190000;

hair; Kramer, Cosmo; INT; MKT; 185000;

imagine; Lennon, Juan; INT; MKT; 210000;

jaws; Leno, Jay; IBM; STR; 130000;

jingo; Santana, Carlos; MSF; PROD; 230000;

julia; Benes, Elaine; HEI; ACCT; 210000;

kick; Hamm, Mia; AOL; STR; 200000;

kwack; Duck, Donald; INT; ACCT; 175000;

legend; Navratilova, Martina; HEI; MKT; 220000;

likeprince; Parker, Camila; BLO; FIN; 145000;

money; Trump, Donny; AOL; STR; 200000;

news; Couric, Katie; AOL; MKT; 175000;

nyny; Sinatra, Franky; INT; ACCT; 190000;

power; Winfrey, Oprah; BLO; FIN; 215000;

preppy; Lauren, Rafael; BLO; PROD; 200000;

pulp; Travolta, Johnny; INT; PROD; 170000;

signe; Clapton, Eric; MSF; FIN; 180000;

slalom; Street, Picabo; DEL; PROD; 180000;

talldude; Johnson, Magic; BLO; STR; 140000;

taxidriver; De Niro, Robert; INT; FIN; 210000;

time; Stewart, Martha; IBM; HR; 198000;

topten; Letterman, Dave; IBM; ACCT; 210000;

travolta; Vega, Lucent; BLO; STR; 255000;

uk; Blair, Tony; IBM; MKT; 180000;

unionst; Krauss, Alison; BLO; FIN; 165000;

vegas; Crow, Sheryl; INT; FIN; 185000;

view; Walters, Barbie; IBM; MKT; 235000;

waves; Hamilton, Laird; BLO; PROD; 200000;

wreck; Branch, Michelle; DEL; ACCT; 200000;

xxx; Espinosa; DEL; FIN; 1000000;

xxxxx; hariceh; DEL; ACCT; 22222;

test; Offsie, Josh; IBM; MKT; 64000;

zeppelin; Page, Jimmy; AOL; STR; 175000;

Please navigate back to the prior page