Can we use max in where clause?
No Answer is Posted For this Question
Be the First to Post Answer
What is the cartesian product of table?
Do you know how to send email from database?
how can u get last observation in an unknown dataset ?
What is data source document?
Is it true, that there is no difference between a rule and a check constraint?
How to enforce security in sql server? : sql server security
Normalization and denormalization
What does set rowcount do?
Explain relational data?
Explain the dbcc pintable command when would you use it?
What is the role that is required for killing a process What is the role that is required for creating a linked server
1 Answers CarrizalSoft Technologies, IBM,
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 500