如何按名字和姓氏在不同行中显示重复行grupe?
我有下面的代码:
SELECT LASTname, FIRSTname, COUNT(*) AS dupes
FROM TCPD_PERSONEL
GROUP BY FIRSTNAME, LASTNAME,
HAVING (COUNT(*) > 1);
当我运行此命令时,出现:
lastname firstname dupes
Ion Alin 2
但我想要看起来像这样:
lastname firstname email
Ion A
我想要计算两个不同的表,我尝试下一个代码,但它给我的结果只有gal表。我需要修改以获得行数如何在gal和TLP中复制
代码是:
SELECT name, GIVEN_NAME, mail, COUNT(*) AS DUPS
FROM Glob
WHERE ( NOT EXISTS (SELECT email1
FROM TLP
WHERE GLOB.mail = TLP.email1 )
AND GLOB.mail IS NOT NULL )
AND (
我有两个表: gal和TCPD_personel_COPY。我想插入在TCPD_PERSONEL_COPY中,用户是在gal中,但还不存在于TCPD_PERSONEL_COPY与条件gal.country='Germany'。但我也有条件:
(gal.name not like '07_%'
gal.name not like 'TR_%'
gal.name not like 'ST_%'
gal.name not lik
我在hosts.deny中有这个内容(最后有一个新行):
#
# hosts.deny This file describes the names of the hosts which are
# *not* allowed to use the local INET services, as decided
# by the '/usr/sbin/tcpd' server.
#
# The portmap line is redundant, but it is left to remind you that
# the new secure p
我想让一堆网站在我的电脑上无法访问。
我的hosts.allow文件:
sendmail: all
# /etc/hosts.allow: list of hosts that are allowed to access the system.
# See the manual pages hosts_access(5) and hosts_options(5).
#
# Example: ALL: LOCAL @some_netgroup
# ALL: .foobar.edu EXCEPT terminalserver.foo
我想禁用rsh和rlogin。我已经在iptables中禁用了513和154端口,但我仍然可以在另一台主机上使用rsh登录。我正在使用Debian7.8 32位
我的/etc/inetd.conf在这里
# /etc/inetd.conf: see inetd(8) for further informations.
#
# Internet superserver configuration database
#
#
# Lines starting with "#:LABEL:" or "#<off>#" should not
# be ch
问题
因此,在从Ubuntu服务器8.04->10.04->12.04升级后,我遇到了这个问题。
初始命令
apt-get install -f
dpkg: warning: files list file for package `tcpd' missing, assuming package has no files currently installed.
dpkg: warning: files list file for package `python-pkg-resources' missing, assuming package has no fil
[ 2 root ] $ cat /etc/securetty
#
# This file contains the device names of tty lines (one per line,
# without leading /dev/) on which root is allowed to login.
#
tty1
tty2
tty3
tty4
tty5
tty6
rsh
rlogin
rexec
[ 3 root ] $ cat /etc/xinetd.d/rsh
# default: off
# description:
# The rshd server is a ser
我刚刚将我的WSL安装从16.04升级到18.04,但不知道如何处理升级提示中的以下行:
4 installed packages are no longer supported by Canonical. You can
still get support from the community.
我检查了细节,所以我有一个不受支持的软件包清单-gcc-5-基,gcc-6-基地,subversion和tcpd在我的情况下-但我还没有找到任何关于我应该如何处理这些信息的在线。
我应该把那些包裹拿掉吗?用别的东西代替他们?忽视他们不再被支持的事实?
我在一列上有两个不同维度的表,如下所示:
name varchar2(256 char)
在表格中,我想插入的是
lastname varchar2(50 byte)
当我编译下一段代码时:
INSERT INTO TCPD_PERSONEL_COPY
( FIRSTNAME,LASTNAME, EMAIL1)
SELECT NAME,GIVEN_NAME, MAIL
FROM glob
WHERE ( NOT EXISTS (SELECT EMAIL1
FROM tlp
我有带有1040Mib的/dev/sda11 11,并创建了名为vg3的VG。
我没有提到-s的体育,所以它花了4个PE。我可以删除它,但我想改为体育16。
当使用vgchange -s命令时,我得到了错误。
[root@r1 ~]# vgchange -s 16 vg3
New extent size is not a perfect fit
<[root@r1 ~]# vgdisplay vg3
--- Volume group ---
VG Name vg3
System ID
Format lvm2
为了不让输出掩盖问题,
我正在尝试运行autoremove
我查过了。
它断了。
在此之后,没有任何东西显示为autoremove-able。
现在还存在autoremove列表上的内容吗?
我想再试一次autoremove。
# sudo apt-get autoremove
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
amd64-microcode aspnet