Query

Question

Query

care.shiv

Grasshopper

Points: 14
More actions
December 11, 2009 at 7:44 pm

#73974

select 10 from emp;
Is it correct query?
If it is correct what will be the result of this query .............
specify reason also

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

If emp is a table you will get exactly what you asked for, 10 for as many rows as are in emp.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jeff Moden SSC Guru Points: 1004646 More actions · Answer 2

care.shiv (12/11/2009)
select 10 from emp;
Is it correct query?
If it is correct what will be the result of this query .............
specify reason also

Why don't you just try it instead of asking us a test/homework/interview question? 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 738877 More actions · Answer 3

If this is homework/exam/interview question, it's not our intent to do the work for you. As mentioned by Jeff, you should try it. If you can't try it, then perhaps you should not be asking us.

If you don't understand the results, then show us that you've tried it, what you think, and ask for an explanation. We are more than happy to help, but we do not want to do work for you.

care.shiv Grasshopper Points: 14 More actions · Answer 4

hi

select 10 from emp

I was tried this query and i got following result, So my question is what is logic behind this answer

10

---

10

Steve Jones - SSC Editor SSC Guru Points: 738877 More actions · Answer 5

the logic is

SELECT xxx

from EMP

will return a row for every row in the EMP table. If xxx is a column, it returns the values from that column. In your case, you have listed a scalar value, so it is returned. Once for each row in emp.

Jeff Moden SSC Guru Points: 1004646 More actions · Answer 6

No way to explain it better than that, Steve.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)