SQL Retrieve Data Exercise

In this chapter, you will get some questions based on retrieve data commands.

Exercise

1. What is select statement?
2. Write a statement to display or retrieve all records of humanresources.employee table.
3. What is different between distinct and top command?
4. Write an statement to use IN clause.
5. With detail write about SQL function Avg(), Count(), Min(), Max().
6. What is different between IN and EXISTS clause?
7. What is different between group by and compute by?
8. What is use of order by statement? Write an statement to use order by and display data in decending order.
9. Write a statement to use between clause.
10.Write something about function sum().


SUMMARY

In this chapter, you have got some exercise questions based on retrieve data. In the next chapter you will learn about storing data.

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.