Archive for category HIZLI ERİŞİM

sql find duplicate record using fields

 

SELECT COUNT(id)
FROM  Employee
GROUP BY id
HAVING ( COUNT(id )>1 )

 

using two fields

SELECT
    name, email, COUNT(*)
FROM
    users
GROUP BY
    name, email
HAVING 
    COUNT(*) > 1
Advertisements

Leave a comment

how-to-display-a-line-break-with-outputtext

 

 

<h:outputText value="&lt;br/&gt;" escape="false" />


http://stackoverflow.com/questions/3337331/how-to-display-a-line-break-with-outputtext

Leave a comment

escaping ampersand in url

 

http://stackoverflow.com/questions/1693595/can-we-use-in-url

 

&amp;

<h:commandLink value=” display”
onclick=’window.open(“http://google.com/3101&amp;entity_id=102&amp;pid=99&#8221;);’>
</h:commandLink>

,

Leave a comment