SQLÖظ´¼Ç¼²éѯɾ³ý
1
¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select
*
from
people
where
peopleId
in
(
select
peopleId
from
people
group
by
peopleId
having
count
(peopleId)
>
1
)
2
¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´Åжϣ¬Ö»ÁôÓÐrowid×îСµÄ¼Ç¼
delete
from
people
where
peopleId
in
(
select
peopleId
from
people
group
by
peopleId
having
count
(peopleId)
>
1
)
and
rowid
not
in
(
select
min
(rowid)
from
people
group
by
peopleId
having
count
(peopleId )
>
1
)
3
¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¨¶à¸ö×ֶΣ©
select
*
from
vitae a
where
(a.peopleId,a.seq)
in
(
select
peopleId,seq
from
vitae
group
by
peopleId,seq
having
count
(
*
)
>
1
)
4
¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¨¶à¸ö×ֶΣ©£¬Ö»ÁôÓÐrowid×îСµÄ¼Ç¼
delete
from
vitae a
where
(a.peopleId,a.seq)
in
(
select
peopleId,seq
from
vitae
group
by
peopleId,seq
having
count
(
*
)
>
1
)
and
rowid
not
in
(
select
min
(rowid)
from
vitae
group
by
peopleId,seq
having
count
(
*
)
>
1
)
5
¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¨¶à¸ö×ֶΣ©£¬²»°üº¬rowid×îСµÄ¼Ç¼
select
*
from
vitae a
where
(a.peopleId,a.seq)
in
(
select
peopleId,seq
from
vitae
group
by
peopleId,seq
having
count
(
*
)
>
1
)
and
rowid
not
in
(
select
min
(rowid)
from
vitae
group
by
peopleId,seq
having
count
(
*
)
>
1
)
(¶þ)
±È·½Ëµ
ÔÚA±íÖдæÔÚÒ»¸ö×ֶΓname”£¬
¶øÇÒ²»Í¬¼Ç¼֮¼äµÄ“name”ÖµÓпÉÄ
Ïà¹ØÎĵµ£º
What is SQL*Plus and where does it come from?
SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers ......
È«ÎÄËÑË÷µÄºËÐÄÒýÇ潨Á¢ÔÚMicrosoft Full-Text Engine for SQL Server (MSFTESQL) ·þÎñÌṩ֧³Ö
Ãæ¶Ôº£Á¿µÄÊý¾Ý£¬ÈçºÎ²ÅÄÜÕÒµ½ÎÒÐèÒªµÄ£¿¶ÔÊý°ÙÍòÐÐÎı¾Êý¾ÝÖ´ÐеÄLIKE ²éѯ¿ÉÄÜÐèÒª»¨·Ñ¼¸·ÖÖÓʱ¼ä²ÅÄÜ·µ»Ø½á¹û£»µ«¶ÔͬÑùµÄÊý¾Ý£¬È«ÎIJéѯֻÐèÒª¼¸Ãë»ò¸üÉÙ ......
SQLÓï¾äÓÅ»¯Êµ¼ùÖ®Ò»SQL_TRACE
»·¾³£ºÔÚPL/sqlÉϵ÷ÊÔÊý¾Ý
Pl/sql developer¹¤¾ßÁ¬½ÓʵÀýºó¼´×÷Ϊһ¸öÓû§½ø³ÌÕ¼ÓÃÒ»¸ösession£»
select * from v$session t where t.PROGRAM='plsqldev.exe' and t.USERNAME='DZJC'
²éѯ½á¹ûÏÔʾÁ˼¸¸ö¹Ø¼üµÄ×Ö¶Î
SADDR RAW(4) S ......
Sql´úÂë:Powered by chenjiazi
--²éѯµ±Ì죺
select * from info where DateDiff(dd,datetime,getdate())=0
--²éѯ24СʱÄÚµÄ:
select * from info where DateDiff(hh,datetime,getDate())<=24
--infoΪ±íÃû,datetimeΪÊý ......
1¡¢µÚÒ»²½£¬Ñ¡ÖÐÒªÇå³ýÈÕÖ¾µÄÊý¾Ý¿â——ÓÒ¼ü——ÊôÐÔ¡£
2¡¢µÚ¶þ²½£ºÔÚÑ¡ÏîҳѡÖГѡÏ¬»Ö¸´Ä£Ê½Ñ¡Ôñ“¼òµ¥”£¬µã»÷×îϱßÈ·¶¨°´Å¥¡£
3¡¢µÚÈý²½£¬ÔÙÑ¡ÖÐÊý¾Ý¿âÓÒ¼ü——ÈÎÎñ——ÊÕËõ——Êý¾Ý¿â¡£
4¡¢µÚËIJ½£¬µã»÷&ldq ......