Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arunb76
Starting Member
1 Post |
 Posted - 2007-06-23 : 10:34:32
|
| hi, I want to help for the following situations 1) I want to find third maxiumum value from the table using a single query. is it possible? then how please specify the complete query 2) I have so many rows are repeated in a table. I want to delete all the repeated rows form the table using a single query. is it possible? then how please specify the complete queryArun |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-23 : 11:31:26
|
| provide some sample code and expected output so its easier for us to help you with a query. In fact, look in the FAQ post under "New to SQL Server" sections. Perhaps your question is already answered there.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-06-23 : 15:28:29
|
| Don't job interviewers ever come up with new questions?CODO ERGO SUM |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-23 : 23:14:48
|
These are like the fundamentals of any TSQL logic I think..so dont think it will go away any soon unless MS provides some "direct" SELECT statements for these and they become as simple as regular SELECT statements...  Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
pbguy
Constraint Violating Yak Guru
319 Posts |
Posted - 2007-06-24 : 23:42:50
|
| Arun,Search this forum for your questions...u will get more answers--------------------------------------------------S.Ahamed |
|
|
|
|
|
|
Sql query