![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions In SQL. (DB2)there is one Dept table and other Emp tableQuestion- select Emp Name from Emp whose Dept No. is not in Dept table and it is present in Emp table Plz tell the Query? Read Answers (8) | Asked by : dinesh Latest Answer : select distinct (a.sal) from emp a where &n=(select count (distinct(b.sal)) from emp b where a.sal Read Answers (14) | Asked by : ramaprasad Hey there SQL MASTERS, here are some questions i was posed in an interview/assessment thing, dunno how well i did....Coud u answer these questions? i dont know how easy/difficut they are for u, all i know is that i had SERIOUS trouble with them! thanks alot!EMPLOYEEEmployee_id number NOT NULL (Primary Key)Employee_name VarChar(30) NOT NULL Dept_id number NOT NULL (Foreign Key to DEPARTMENT)Manager_id number NOT NULL (Foreign Key to EMPLOYMENT)Salary number Read Answers (6) | Asked by : zen Latest Answer : In Trigger there is a special Table Called INSERTD. it takes the value from transation log.In the After Insert Trigger....SELECT Id,Name FROM INSERTEDyou can catch these values in a variable. ... Read Answers (4) | Asked by : Mahendra raja Latest Answer : delete from table_name1 t1 where exists ( select * from table_name1 t2 where t2.keyvalue1=t1.keyvalue1 ... Read Answers (14) | Asked by : Anita Latest Answer : If you are looking for an SQL server 2005 query then the following:SELECTÂ Â Â Â rowidFROMÂ Â Â Â Â Â Â Â empWHEREÂ Â Â Â (rowid =Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â (SELECTÂ Â Â Â COUNT(*) AS Expr1Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ... Read Answers (12) | Asked by : A Latest Answer : select * from (select * from(select * from emp order by sal desc) where rownum ... Read Answers (43) | Asked by : suman How to get fifth maximum salary from the table with out using TOP keywork(without any keywords) in sql server 2000Can you please guide me about this? I am writing a script to update a value in an Oracle table. The script has a 'From' clause which Oracle does not like. Is there another way to write this since I am bringing data from 3 different tables.ThanksSamir Read Answers (1) | Asked by : Samir Latest Answer : select * from tab; ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||