SQL ,PLSQL , Unix

1. Write an SQL statement to delete all duplicate rows in a table.    Give all possible SQL statements that can be used to delete duplicate rows effectively. 2. Consider the following table ID Name Role ManagerId MGR6002 RajeshKumar Manager MGR1001 TM1001 Sridevi Associate MGR6002   TM1002 John Sr.Associate MGR6002 TM1008 Rexan Associate MGR6002   MGR6003 Amruta Manager MGR1001 MGR6004 Justin Manager MGR1001   MGR1001 Ravikumar GPM VCH1001 TM1003 Linton Associate MGR6004   TM1003 Kavitha Sr.Associate MGR6004 TM1005 Sailu Analyst MGR6002   TM1006 Sami Sr.Associate MGR6001       Write an SQL to print employee list hierarchically     Ex output. Rajeshkumar John Rexan Sailu Amruta Justin Linton Kavitha 3. Write the SQL statement to obtain nth salary of employees. 4. Wha...

whoami The command lets you know the user name of the current shell you are at. Example: root@Microknoppix:/home/knoppix# whoami root root@Microknoppix:/home/knoppix# su knoppix knoppix@Microknoppix:~$ whoami knoppix su The su command is used to become another user during a login session. Invoked without a username, su defaults to becoming the superuser. The optional argument - may be used to provide an environment similar to what the user would expect had the user logged in directly. Example : root@Microknoppix:/home/knoppix# su knoppix password: knoppix@Microknoppix:~$ knoppix@Microknoppix:/root$ su - password: root@Microknoppix:~# knoppix@Microknoppix:/root$ su password: root@Microknoppix:~# finger The finger displays information about the system users. Example: root@Microknoppix:~# finger knoppix Login: knoppix Name: Knoppix User Directory: /home/knoppix Shell: /bin...

Dear readers, Apologies! I have been away so long since my last post.  Here you go! I will try to continue my blogging at least frequently if not everyday. Thank you! Enjoy learning!!!