Select All Records With Duplicates

I wanted to select all records with duplicate session numbers (session_number) from my forms table so I’ll know if there are error of duplicate entries. I’m using MySQL Database.

Select All Records With Duplicates
Select All Records With Duplicates

Here’s a solution I found:

SELECT session_number
FROM forms
GROUP BY session_number
HAVING COUNT( session_number) > 1


SELECT session_number
-I’m just selecting session_number

FROM forms
-I’m selecting records from forms table.

GROUP BY session_number
-This will group all the session_number.

HAVING COUNT(session_number) > 1
-After grouping the session numbers, we will count records with that group’s session number. If it is greater than 1, it means it has duplicates, so it will be selected.

That’s it! 🙂


Maintain A Balance between Creativity and Business Objectives while design Website.

Creativity is not a limited thing. Agreed; but when it comes to designing a website or web application for an online business, there are certain basic rules to be followed. Well, if it matches the theme of the website – go ahead! But it creates a lot of work if you try to mix and match just all designing skills in one part of page! Website design is all about matching the business objectives to the design portal.

Before we get into what are the does and doesn’t.: Make your website design look as though you mean as per your business! Let’s take a short look at a few best practices in website design:

  • Keep the design simple and sober. The very basic design rule. what they can do for you. Leave very little for the users to figure out.
  • If your website design represents a professional business or organization, avoid too many flash animations or graphics. Maintain a classic and light color scheme. Not too dull – not too bright. However, if it is for a gaming website or something that spells “fun” – let your imagination go to high animation, flash, graphics!
  • Background and text contrast – do not let your text get lost amidst the textured background. Customers need to read the text! (Background is an add-on)!
  • Describe via graphics, maps, – yes – go ahead!
  • Heading and main text separators – use bold, Italics – avoid blinking text – it’s annoying for someone who is looking for important information!

Of course using imagination, you can do the best web designs. So, all these does and does not are not meant to discourage you from using your extra creativity in website design. It’s just so that you know where creativity ends and professionalism begins. It just right is the key to a good website design.

With all this said, always remember that the ultimate aim of an online business is to make a business growth. And a good website design can contribute in many – many ways towards this goal or aim.

Infilon Technologies Pvt. Ltd. providing Web Design in India and Worldwide. The main services provided here are Web Design and Web Development, Internet Marketing, Graphic Design, Search Engine Optimization, and other IT services.


Internet Television Information

The word Internet is very high and has a large content for the consumption of its users. It has now become the necessary of the computer systems. Without it PCs are useless because we can do each and everything via internet. From its vas uses one more very interesting use is Internet Television.

With internet television feature of the internet we can now experience the information and presentations in the form of a download or view content according to category from our computers. It provides the content from a varied range of sources from any part of the world. There are lots of shows can be found which are not available on the television. There can be different reasons like small audience or location problems. Now viewing can be limited for the viewers in a manner which can be possible by only DVRs and other cable channels packages. In this case many producers who introduce their content/serials in niche audience can easily deliver via internet.

There are lots of websites providing the offerings for the users so that they can easily navigate to the content they are interested in viewing their contents. Users have also choice to find their content of interest from specific countries, sources and in different languages. Many sites are providing the feature of listings and giving access to different varieties for shows from a region, with this user can easily follow different cultures and values anywhere on the globe.

The basic type of delivery are downloading and streaming. Now download is very simple and it doesn’t need the relatively same bandwidth like streaming. The number of the viewers for this content/serials is generally big. If you do not have time to watch a show you can subscribe to it so that a link will be mail to you and then you can open it easily and watch at any time. These shows you can watch on your personal computer as well.

The next feature of viewing is streaming which deliver the program to you when it is delivered live over the internet. You can tune in to the television shows as well on their particular time. Most of the bigger internet services provider can develop their own offerings of the internet protocol television and these offerings are made by the providers you buy your internet service. The process of streaming mostly requires good computer power and good speed of the internet capable to handle large data with higher speed. It is becoming popular in mostly in those workplaces where people do not have a particular television to watch but have a computer system.

Infilon Technology is an SEO consultant providing a wide range of SEO services from fixed price SEO packages through to high level SEO consultant services. It also provide services like web design, software developing, web hosting etc…