Simple trick on how to play an audio or video file using Command Prompt

Command prompt are normally used for the Easy access and Important changes to be made in the Computer.well you can use it for playing the Audio, and Video too.

This is how we can play Audio with the Command Prompt

1) Press Windows+R and get the RUN box

2) Type "cmd" in it, the command prompt box will opens

3) Type the Path Name of the File, e;g D:/Song .

4) In more Detail D:/Users/songs/song.mp3

5) Extension should be given to the song , Otherwise it wont play.

4) Now the Song will be played, you can listen the Song and Enjoy

This is how we can play Video with the Command Prompt

1) Press Windows+R and get the RUN box

2) Type "cmd" in it, the command prompt box will opens

3) Type the Path Name of the File, e;g D:/Video .

4) In more Detail D:/Users/Videos/Video.mp4

5) Extension should be given to the Video , Otherwise it wont play.

4) Now the Video will be played, you can Watch the Video and Enjoy.

How to find out Max Salary from each department

You can find maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum salary in each group or each department. SQL Query: SELECT DeptID, MAX(Salary) FROM Employee GROUP BY DeptID. This questions become more interesting if Interviewer will ask you to print department name instead of department id, in that case you need to join Employee table with Department using foreign key DeptID, make sure you do LEFT or RIGHT OUTER JOIN to include departments without any employee as well. Here is the query

List the emps who joined before 1981.

Answer: select * from emp where hiredate < (’01-jan-81’);

SQL Info

Search This Blog