What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....9 59519
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 3013 13996
How to select nth record from a table?13 34769
What are the factors you will check for the performane optimization for a database query?7 8909
Why is quicksort not stable?
Explain in detail about the advantages and features of json?
Explain python variable scope error?
How define set in java?
What is the difference between sga and pga?
Define fashion color?
What is the maximum size of mysql database?
What is the primary key of pc_assign_worklist?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Why netstat command is used?
what is the difference between two and three-tier architectures?
What are the data classes in abap?
Define GAAR and GST.
How to size fuse? How to size MCB?
What happens if the block in HDFS is corrupted?