44 45 46 47 48 49 50 51 52 53 54 55 56 57 Use MarchDB -- sub query within from clause select pname,pprice from (select * from product) as t --sub query within where clause with logical operators ...

When writing scripts, it is best practice to filter the result set by using the WHERE clause. Also, minimize the result set by restricting the number of columns queried by using the columns names ...