Who am I?

From SQLZoo
Jump to navigation Jump to search

Who am I - what is my user id?

schema:gisq

Find the user name or user id. The SQL standard permits the function USER

SELECT user FROM anyoldtable
SELECT user FROM anyoldtable
SELECT user FROM anyoldtable
SELECT user FROM anyoldtable
select user
SELECT user, uid FROM dual
USE scott;
SELECT user, user_id();
USE gisq;
SELECT user, user_id()
SELECT user()
SELECT user FROM anyoldtable
USE scott;
SELECT user, user_id();
USE gisq;
SELECT user, user_id()
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects