I was in need to pass a max value in where condition. My folly, what i did is : Incorrect : Select * from table_name where field = MAX(fi...

  I was in need to fetch top n rows from a particular table in DB2. I got below mentioned error when tried with some incorrect syntax.  42...

I got below mentioned error while updating a View in DB2.  42807(-150)[IBM][CLI Driver][DB2/SUN64] SQL0150N  The target fullselect, view,...

Step 1. Download MySQL Installer (mysql-advanced-5.5.8-win32.msi) file from the website of MySQL  http://www.mysql.com/ Go to URL htt...

Query : SELECT TABNAME,COLNAME from SYSCAT.COLUMNS where TABNAME= ' table_name' You can use above mentioned query for getting ...