Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 50014 13250
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h1 1889
how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?9 18533
A left outer join B B right outer join A gives the same result then what is the use of two?1 3568
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?977
A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?2 3191
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)1 9959
What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query2 3940
what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?2 12482
Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key1 8891
What is best institute to Learn DotNET And SQL in chennai?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Why do you want to join software field as you have done your BE in Electronics?
ow to bring suspect mode datbase online from scratch
How to convert a table data in XML format in sql server?
what is the sql equivaent of the dataset relation object ?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
role of sql sever 2005 in database rather than any other database
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.