sql - In MySQL, what does this simple nested SELECT clause mean exactly? -

-

here example thread:

select (   select distinct salary employee order salary desc limit 1 offset 1 )as second;

the select(...) second looks confusing me because i've never seen query-set instead of column names can used argument of select..

does have ideas how understand nested select clause this? there tutorials feature?

that's subquery in select list of query.

to there, let's @ other examples

select t.id      , 'bar' foo    mytable  ...  limit ...

'bar' string literal gets returned in every row (in column named foo) in resultset query.

also, mysql allows run query without clause

select 'fee' fum

we can put subquery in select list of query. example:

select t.id      , (select r.id resorts r order r.id asc limit 1) id   mytable  ...  limit ...

the query pattern asked select statement without clause

and expression being returned result subquery.

for example:

 select e.salary     employee e   group e.salary   order e.salary desc   limit 4,1

if query runs, return 1 column, , return either 1 or 0 rows. (no more one.) satisfies requirements subquery used in select list of query.

select ( subquery ) alias

with that, outer query executes. there's no clause, mysql returns 1 row. resultset going consist of 1 column, name of "alias".

for each row returned outer query, mysql execute subquery in select list. if subquery returns row, value of expression in select list of subquery assigned "alias" column of resultset. if execution of subquery doesn't return row, mysql assigns null "alias" column.


Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more