create database exampleDB with owner exampleowner encoding 'UTF8'; //创建库 create user exampleowner superuser password 'example'; //创建超级角色 /usr/local/pgsql/bin/psql -U postgres -c "select
select prod_id,prod_price,prod_name from products order by prod_price desc,prod_name; \\降序排序prod_price 如果有重复再按prod_name排序 select prod_name,prod_price from products where prod_price between 5 and 10
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号