pavan_teja

I am looking for query to select the last row of a table. Please help.

I had a small issue. Can you pls check this... I have two tables TABLEA,TABLEB. TABLEA -------------- col1 col2 col3 TABLEB -------------- cl1 cl2 cl3 If col2 in TABLEA = cl2 in TABLEB, then i need to update cl3 in TABLE B with col3 in TABLE A. I tried running …

I need a little help with a query . I have attached an example table (roughly) in attached picture. The table has a serial number, a supplier_id and a weight column. We need to retrieve FOR each supplier the row that has maximum weight. There could be duplicate rows if …

[ATTACH=RIGHT]16400[/ATTACH]Today [URL="http://uwnews.org/article.asp?articleID=59530"]University of Washington researchers scored a triumph[/URL] in the ongoing battle for domination of the planet by demonstrating that sometimes humans are better at video games. The announcement came from David Baker, a biologist at the Howard Hughes Medical Institute, and Zoran Popovic and Seth Cooper, computer scientists at …

Hi Guys, Some Fake warnings are spreading on face book like this: [B]ATTENTION!!!!!!-Virus spreading like wildfire on Facebook!![/B] -->It is a Trojan worm called "Knob Face". It will steal your info, invade your system and shut it down! -->DO NOT open the link "Barack Obama Clinton scandal". -->If "Smartgirl 15" …

Can anyone help me? Can i know what is the difference between superkey and primary key? what is actually candidatekey?

Hi all, I try to view latest date and amount from history table for each branch (branch table :viscawangan). But accouter problem to view [B]amount [/B]value. [CODE] SELECT b.kod_cawangan,b.nama_cawangan, MAX( a.tkh_data ) AS tarikh_data,[B]a.amount[/B] FROM history a, viscawangan b WHERE a.kod_caw = b.kod_cawangan GROUP BY kod_caw [/CODE] Here i give …

Hi guys, When you try to create a folder named CON in your windows, you might have have known that you are unable to create because its reserved key word which prevents it from being created. Similarly there are few other reserved names like this... PRN AUX NUL LPT1 COM1 …

Hallo dont now if its right forum and excusse for bad english. I hawe a site on one.com and tried to restore my sql data base. i hade a backup, before i restored it i dropped all the thables to read in the new wone. buth it dosent work it …

Hi, Recently i hava a problem to rename a folder. That is i'm able to rename anything to a folder. But i'm unable to rename as [B]CON[/B] to any folder. Is it windows bug or anything else?

Hi guys, Did you know that a flight number from one of the planes that hit one of the two WTC towers on 9/11 was Q33N. In Notepad / WordPad or MS Word, type that flight number i.e. Q33N. Increase the font size to 72. Change the font to Wingdings. …