Contents:
which resources are the best for learning it?
Why do you need to use subqueries only?
Just asking for direction?
Can you write query with join?
do you fucker think that i am asking here wthout google?
Why are you an exception?
which resources are the best for learning it?
Why do you need to use subqueries only?
Just asking for direction?
Can you write query with join?
do you fucker think that i am asking here wthout google?
Why are you an exception?
piterden 2020-10-03 10:48:51
2020-10-03 09:54:29
which resources are the best for learning it? eg-: sql subqueries with INSERT statement, UPDATE statement, and DELETE statement?
I suppose Google
MasterZiv 2020-10-04 18:02:12
2020-10-03 09:54:29
which resources are the best for learning it? eg-: sql subqueries with INSERT statement, UPDATE statement, and DELETE statement?
Martin gruber introduction to sql
2020-10-04 18:02:27
piterden 2020-10-03 10:48:51
I suppose Google
already googled dude
2020-10-04 18:02:30
but understood already
2020-10-04 18:02:40
there were not much good resources in gooogle
2020-10-04 18:17:13
MasterZiv 2020-10-04 18:02:12
Martin gruber introduction to sql
thanks bro
2020-10-04 21:58:59
2020-10-04 21:59:06
question-:
2020-10-04 21:59:24
How to find bname,publication, author where publication=”Y” USING ONLY SUBQUERIES?
2020-10-04 21:59:32
Assume the name of 1st table as “book table” and the 2nd table as “booklist table”.
piterden 2020-10-04 22:35:37
2020-10-04 21:59:24
How to find bname,publication, author where publication=”Y” USING ONLY SUBQUERIES?
Why do you need to use subqueries only?
minefolelser 2020-10-05 00:19:49
piterden 2020-10-04 22:35:37
Why do you need to use subqueries only?
It might be a homework)
piterden 2020-10-05 00:29:00
minefolelser 2020-10-05 00:19:49
It might be a homework)
We are here not for make someone’s homework instead of him
2020-10-05 05:38:11
piterden 2020-10-05 00:29:00
We are here not for make someone’s homework instead of him
Is there any problem with hws
2020-10-05 05:38:18
if i don’t ask you to solve it?
2020-10-05 05:38:25
Just asking for direction?
2020-10-05 05:38:42
most people will have to learn while during homeworks and assignments, i don’t find anything wrong with it.
2020-10-05 05:38:57
i guess everyone here knows how hard it is to put time to learn sth extra
piterden 2020-10-05 07:53:39
2020-10-05 05:38:25
Just asking for direction?
The direction is to write a query with subquery instead of join.
2020-10-05 07:54:08
any good resources to learn it
?
?
2020-10-05 07:54:11
u could share?
2020-10-05 07:54:19
no need to get aggressive like a troll.
piterden 2020-10-05 07:54:53
Can you write query with join?
piterden 2020-10-05 07:56:48
2020-10-05 07:54:08
any good resources to learn it
?
?
There is only one resourse. Google
piterden 2020-10-05 07:56:50
https://www.google.com/search?q=replace+subquery+with+join&oq=replace+subqu&aqs=chrome.1.69i57j0l7.8788j1j7&sourceid=chrome&ie=UTF-8
replace subquery with join – Google Search – Google
2020-10-05 07:57:02
lol troll fuck you
2020-10-05 07:57:15
i have learnt more things from google than u asshole
2020-10-05 07:57:20
get a life
2020-10-05 07:57:22
dude
2020-10-05 07:57:28
never seen such a troll fucker
piterden 2020-10-05 07:57:30
https://www.google.com/search?newwindow=1&q=replace+join+with+subquery&oq=replace+join+with+sub
replace join with subquery – Google Search – Google
2020-10-05 07:57:43
do you fucker think that i am asking here wthout google?
piterden 2020-10-05 07:58:06
I’m not a troll. Are you crazy?
2020-10-05 07:58:08
i am asking specific resources like sqlbolt.com is good for basics
2020-10-05 07:58:15
some books are good for some parts
2020-10-05 07:58:22
i read understanding sql book but there was not much
2020-10-05 07:58:33
about subquery related to select and where
piterden 2020-10-05 07:58:35
You need only Google to solve it
2020-10-05 08:00:03
i have been gogling
2020-10-05 08:00:07
and faild to get it
2020-10-05 08:00:11
in 24 hours
2020-10-05 08:00:15
so askng.
piterden 2020-10-05 08:02:38
Can you write query with join?
piterden 2020-10-05 08:03:12
2020-10-05 08:00:15
so askng.
Hey, answer please
2020-10-05 08:04:19
piterden 2020-10-05 08:02:38
Can you write query with join?
yes
2020-10-05 08:04:20
i guess
piterden 2020-10-05 08:04:31
Show it
MasterZiv 2020-10-05 09:12:02
2020-10-04 21:59:24
How to find bname,publication, author where publication=”Y” USING ONLY SUBQUERIES?
At least one quiery had to be used, the main quiery, 1) because you can’t select anything without a quiery, 2) a subquery can’t be used without a quiery.
So your task is strange.
MasterZiv 2020-10-05 09:13:15
2020-10-04 21:59:24
How to find bname,publication, author where publication=”Y” USING ONLY SUBQUERIES?
Besides, I can’t see a thing on your picture. Try harder and show us the structure in form of text in a message.
MasterZiv 2020-10-05 09:14:43
2020-10-05 07:57:43
do you fucker think that i am asking here wthout google?
80% of people do. Why are you an exception?