联合国-allqahome-开发者的问答家园

English 中文(简体)

联合国

原标题：SQL: nobel prize table on sqlzoo [closed]

It s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.

Closed 11 years ago.

我在互联网上学习并做一些实践。

I cannot find the answer for the problem 4a and 4b on http://sqlzoo.net/2b.htm The table s name is nobel and have 3 colums (yr, subject, winner)

问题是:

展示给物理的三年奖。

赢家不止一次。

增编

最佳回答

http://code>4a:

SELECT yr
  FROM nobel
 WHERE subject =  Physics 
 GROUP BY yr
HAVING COUNT(*) = 3;

4b:

SELECT winner
  FROM nobel
 GROUP BY winner
HAVING COUNT(*) > 1;

问题回答

暂无回答

上一篇：配置文件XML - 图书馆C/C++-Anders, IOS

下一篇：无法连接到服务器数据库系统的启动包的无效长度已被关闭, 收到快速关闭请求( pgadmin postgres docker)

相关问题

SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

难以执行 REGEXP_SUBSTR

I m 查询Oracle 10g。我有两张表格(样本数据见下文)。 i m 试图提取一些领域

SQL Query for Performing Radius Search based on Latitude Longitude

We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...

SQL Query Shortcuts

What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2

PHP array callback functions for cleaning output

I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...

OracleParameter and DBNull.Value

we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...

Running numbers in SQL

I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...

How to get SQL queries for each user where env is production

I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...

热门标签

友情链接

Allggapp Alljchome-教程家园 mvfinale.com-影视剧情大结局大全