SQLのwhere句で指定したフィールドをselect句には含めずに一意のレコードを取得したとします。

English translation: For example, suppose you retrieved/got/obtained unique records...

04:17 Feb 15, 2008
Japanese to English translations [PRO]
Computers: Software
Japanese term or phrase: SQLのwhere句で指定したフィールドをselect句には含めずに一意のレコードを取得したとします。
環境によって非互換が発生する一例をあげるために書かれた一文です。 (データベースがupgradeされたことによる非互換)
taninanet
English translation:For example, suppose you retrieved/got/obtained unique records...
Explanation:
For example, suppose you retrieved/got/obtained unique records...

... in SQL, without including in the SELECT clause the fields specified in the WHERE clause. (直訳っぽいです。意味は通じますが)

... using an SQL statement in which the SELECT cluase does not contain the fields specified in the WHERE clause. (こちらの方がすっきりしています)

おそらく、例えば

SELECT UNIQUE (または DISTINCT) lastname FROM prozuser WHERE country = "Japan";

のようなクエリーのことを指しているのではないでしょうか? SELELECT 句にも、WHERE 句にも複数フィールドを含めることができます。

Selected response from:

RieM
United States
Local time: 08:53
Grading comment
Thank you!!
4 KudoZ points were awarded for this answer



Summary of answers provided
3 +1For example, suppose you retrieved/got/obtained unique records...
RieM
3see explanation
Daniel Felice


  

Answers


10 hrs   confidence: Answerer confidence 3/5Answerer confidence 3/5 peer agreement (net): +1
For example, suppose you retrieved/got/obtained unique records...


Explanation:
For example, suppose you retrieved/got/obtained unique records...

... in SQL, without including in the SELECT clause the fields specified in the WHERE clause. (直訳っぽいです。意味は通じますが)

... using an SQL statement in which the SELECT cluase does not contain the fields specified in the WHERE clause. (こちらの方がすっきりしています)

おそらく、例えば

SELECT UNIQUE (または DISTINCT) lastname FROM prozuser WHERE country = "Japan";

のようなクエリーのことを指しているのではないでしょうか? SELELECT 句にも、WHERE 句にも複数フィールドを含めることができます。



RieM
United States
Local time: 08:53
Specializes in field
Native speaker of: Japanese
PRO pts in category: 47
Grading comment
Thank you!!

Peer comments on this answer (and responses from the answerer)
agree  casey: Nice explanation.
1 day 18 mins
Login to enter a peer comment (or grade)

10 hrs   confidence: Answerer confidence 3/5Answerer confidence 3/5
see explanation


Explanation:
"(Let us suppose that) a unique record was fetched while the fields specified in the SQL 'where' clause were not included in the 'select' clause."

I may be misunderstanding the context of the sentence. It would be helpful to see the rest of the paragraph.

Daniel Felice
United States
Local time: 08:53
Specializes in field
Native speaker of: Native in EnglishEnglish
PRO pts in category: 4
Login to enter a peer comment (or grade)



Login or register (free and only takes a few minutes) to participate in this question.

You will also have access to many other tools and opportunities designed for those who have language-related jobs (or are passionate about them). Participation is free and the site has a strict confidentiality policy.

KudoZ™ translation help

The KudoZ network provides a framework for translators and others to assist each other with translations or explanations of terms and short phrases.


See also:
Term search
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search