Interview questions: using SQL query 10 on A, B, C, D record how to write? A great god please help s-CodePudding

Interview questions: using SQL query 10 on A, B, C, D record how to write? This is a pen test questions, the great god please help solve, thank you

CodePudding user response:

Subject only this sentence?

CodePudding user response:

reference 1st floor selling fruit net reply:

title only this sentence?

yes, the topic is so, don't know how to answer

CodePudding user response:

You take a picture,

CodePudding user response:

The

reference 3 floor selling fruit net reply:

you take a picture,

, the no photos oh, this problem is thought for a long time, still can not answer, so impressive, subject didn't write wrong, is like this

CodePudding user response:

refer to poetry and the distance, 4/f, 1990 response:

Quote: refer to the third floor selling fruit net reply:
photo you,

, the no photos oh, this problem is thought for a long time, still can not answer, so impressive, subject didn't write wrong, this is the

This no head no tail, can write what? Also want to for a long time, in want to what?

CodePudding user response:

reference 5 floor wildwolv reply:

Quote: refer to poetry and the distance, 4/f, 1990 response:

Quote: refer to the third floor selling fruit net reply:
photo you,

, the no photos oh, this problem is thought for a long time, still can not answer, so impressive, subject didn't write wrong, this is the

This no head no tail, can write what? Also want to for a long time, in want to what?

since the interview out of the question, must have the answer, just didn't think solution method

CodePudding user response:

Have passed the first of April, I can only say that this is a neurological problem,

CodePudding user response:

SELECT * FROM table_name t WHERE t.o bj IN (' A ', 'B', 'C', 'D') LIMIT 10;

CodePudding user response:

Oracle does not support limit

Select * from (select fields, rownum rn form table where field in (A, B, C, D)) where A rn<=10
Should be tested rownum usage

CodePudding user response:

This topic is a little god