Related Articles
HTTP Codes Web Page Errors While Browsing
Below are some web page errors you may came/come across while browsing internet. The error ranges are many but below are the ones which will occur mostly. Error 400 – Bad request errorError 401 – unauthorized request errorError 403 – forbidden errorError 404 – Not found errorError 500 -Internal error errorError 501 – Not Implemented […]
Firefox Excel Application Issue
If you are not able to download the excel in Firefox and where it is working fine in Chrome and IE then have a look at below code. To work in Firefox Excel Issue Just add below code in headersheader(“Content-type: application/vnd.ms-excel”); See below for full code header(“Content-disposition: attachment;filename=example.xls”);header(“Content-type: application/vnd.ms-excel”);header(“Pragma: public”);header(“Expires: 0”);header(“Cache-Control: must-revalidate, post-check=0, pre-check=0”);header(“Cache-Control: private”, […]
How to find duplicate rows in Sql or Mysql
You can find duplicate rows in the mysql table, just use below select query, to find duplicate rows in Oracle, Sql, Mysql, DB2. SELECT columnName, COUNT(*) as countFROM selectedTableGROUP BY columnNameHAVING COUNT(*) > 1; You came from below query:how to find duplicate rows in sql server 2008how to find duplicate rows in sql and deletehow […]