Question

Write a query to display all students name whose name is of 6 characters length. Order the results in ascending order based on name.

Answer 1

Answer:

select Student_Name from students where len(Student_Name) =6 order by Student_Name

Explanation:

Answer 2

Answer:

Select Student____Name from student where Len ( Student____Name) = 6 order by student ____ Name