SQL is a most common uses database for small and medium size database. Some times we are fetching problem for generate report from SQL database, here I will show to you how How Generate SQL Report from Table.This is a very simple query & it is also for beginner. stay with us & search the blog for more SQL related post.
we will generate report from the table name is :emp.dept and others are table field. So data will be generate from emp.dept table.
select ename,job,dept.dname,sal from emp.dept