Oracle query Error Analysis: ORA-01791: not SELECTed expression

The table structure is as follows:

Create table HH_BOOK_GOOD (ID VARCHAR2 (32) not null, BOOKID VARCHAR2 (32) not null, GOODID VARCHAR2 (32) not null, goodprice float not null, GOODNAME VARCHAR2 (256) not null, GOODNOTE VARCHAR2 (1024) not null)

Use the following statement to query

Select distinct ID, BOOKID, GOODPRICE from HH_BOOK_GOOD order by GOODID;

Reporting ORA-01791: not SELECTed expression

The reason is that the GOODID field after order by is not in the select query result field, because the distinct keyword is used.

Solution

1. Add this field to select

Select distinct ID, BOOKID, GOODPRICE, GOODID from hh_book_good order by GOODID;

2. If you think the GOODID field is redundant and you really don't want to query it, you can change it to the following:

Select ID, BOOKID, GOODPRICEfrom (select distinct ID, BOOKID, GOODPRICE, GOODID from HH_BOOK_GOOD) order by GOODID;