queries

1> how to select 3rd maximim salary from employee table
which contains empid,name,salary.
2> how to select duplicates from a table which doesnt have primary key
*** Sent via Developersdex http://www.codecomments.com ***
Please post this question in programming.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"murali yesuraj" <murali088@.hotmail.com> wrote in message
news:eUhkM1xnFHA.3304@.tk2msftngp13.phx.gbl...
> 1> how to select 3rd maximim salary from employee table
> which contains empid,name,salary.
> 2> how to select duplicates from a table which doesnt have primary key
>
> *** Sent via Developersdex http://www.codecomments.com ***