pavan_teja

[QUOTE=ranjit07;1334963]i want to know how to retrive 2nd or 3rd last row from table[/QUOTE] This is very easy indeed.... Select * from employee where rowid=((SELECT * FROM employee WHERE rowid=(SELECT max(rowid) FROM employee))-1) to selct 2nd last row in a employee table. Select * from employee where rowid=((SELECT * FROM …

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 …

[QUOTE=1stDAN;1324143]I have found two solutions. First is solution you can get the maximum weight without duplicates. For supplier_id 1 you get only for sr_no 2001 and weight 80 one row. [CODE]select sr_no, supplier_id, weight from (select *, row_number() over (partition by supplier_id order by weight desc) as ronumer from ora_1) …

[QUOTE=CatRambo;1296927][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 …

[QUOTE=teja_dt;1297454]Hi Guys, Some Fake warnings are spreading on face book like this: [B]ATTENTION!!!!!!-Virus spreading like wildfire on Facebook!![/B] BUT THERE IS NO TRUTH IN THIS... Please be aware of this...!!![/QUOTE] I did see something like this... Good one..!!!

I would like to add that The PRIMARY KEY constraint is the column that uniquely identifies each row, is a combination of UNIQUE and NOT NULL constraints. With this type of constraint, UNIQUE prevents duplicates, and NOT NULL prevents NULL values in the column. The below example shows the creation …

Hi dude, Once try this.... You said you want to select the last record, So i suggest you use rownum function.... SELECT b.kod_cawangan,b.nama_cawangan, MAX( a.tkh_data ) AS tarikh_data,a.amount FROM (SELECT b.kod_cawangan,b.nama_cawangan, MAX( a.tkh_data ) AS tarikh_data,a.amount FROM history a, viscawangan b WHERE a.kod_caw = b.kod_cawangan GROUP BY kod_caw) SORT DESC …

[QUOTE=1seo;1302814]PRN AUX NUL LPT1 COM1 A: TO Z: These Several are special file names are reserved by the system and cannot be used for files or folders in MS windows.[/QUOTE] Hey as mentioned in the above post, you can create them using network path instead of physical path say MD …

[QUOTE=kollon;504626]Hallo dont now if its right forum and excusse for bad english. #1007 - Can't create database 'kollon_se'; database exists[/QUOTE] Since you want to load tables with new data, rather than dropping the tables, you can truncate them. Then you can insert new data. Just keep in mind in case …

[QUOTE=AuburnMathTutor;1296768]Call me paranoid, but I hypothesize that at least two of these accounts are owned by the same individual.[/QUOTE] How can you conclude like that. I dont think any body need two accounts

Hey man... I find this really good. How didi you find this. Nice...