Is there any error in this query?SELECT emp.emp_id, emp.fname, emp.lna

→ Mysql
→ Data Types in Mysql

→ Is there any error in this query?

                    
                        
                            
                                
                                    
                                    
                                    1.
                                
                                
                                    
                                        Is there any error in this query?
SELECT emp.emp_id, emp.fname, emp.lname, dep.name FROM employee AS emp INNER JOIN department AS dep ON emp.dept_id = emp.dept_id;

                                    
                                
                            
                        

                        
                                                            
                                    A.
                                    YES
                                    
                                
                                                            
                                    B.
                                    DEPEND
                                    
                                
                                                            
                                    C.
                                    NO
                                    
                                
                                                            
                                    D.
                                    All of above
                                    
                                
                                                            
                                    E.
                                    None of these
                                    
                                
                                                    

                        
                            
                                
                                    Answer» D. All of above

Is there any error in this query?
SELECT emp.emp_id, emp.fname, emp.lname, dep.name FROM employee AS emp INNER JOIN department AS dep ON emp.dept_id = emp.dept_id;

Discussion

No Comment Found

Related MCQs

Reply to Comment

Is there any error in this query?SELECT emp.emp_id, emp.fname, emp.lname, dep.name FROM employee AS emp INNER JOIN department AS dep ON emp.dept_id = emp.dept_id;

Discussion

No Comment Found

Related MCQs

Reply to Comment

Is there any error in this query?
SELECT emp.emp_id, emp.fname, emp.lname, dep.name FROM employee AS emp INNER JOIN department AS dep ON emp.dept_id = emp.dept_id;