Question
To keep latest single record
Answers
delete from sivaemp where rowid not in(select min(rowid) from sivaemp group by empno)//to keep oldest record   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q What are the tools used in organic search engine optimization
  • Q RuPay cards are accepted at all automated teller machines (ATMs) across India under
  • Q Which layer of the atmosphere has electricity conducting layers which make short wave radio transmission possible long distances ?
  • Q How much distance does the earth’s annual circuit round the sun cover?
  • Q How is data retrieved from multiple tables using a single SQL statement?
  • Q Full form of NOS ?
  • Q What country features centrally and ironically in a map of Europe on the reverse face of Euro coins?
  • Q Write Short Notes on Any two bacterial wilt diseases.
  • Q Why Universal Avenue? What do you know about Universal Avenue? Company profile of Universal Avenue?
  • Q Hypothetical: You have been saving for a new car for two years. You now have $6000.00 in your piggy bank and you are planning to purchase the car this weekend. Last night someone broke into your apartment and stole your piggy bank...What happens now?
  • Q In which state was the first edition of the North East Investors Summit held from January 29, 2017?