How to Display structure of the table using SQL

How to Display structure of the table?

DESE Table_name ;

Eg:

DESE student;

* If it is any numeric value the data type we call it as “Number” & if it is any characteristic value the data type we call it as “Varchar”


How to select specific column?

SELECT column_name;
From table_name:

How to select multi columns?

Eg:

SELECT Name, Mark;
FROM Student;


How to select specific row?

Where Close

It helps to select specific row in a table. If you don’t specific where close it will select all the data in your table.

Eg:

SELECT student_no, Marks;
FROM Student;
WHERE Name = ‘AA’

No comments:

Post a Comment

Hi thank you for comment in Assignment Lanka " Book Mark on me' To future references.

Note: Only a member of this blog may post a comment.

Temporary

" Temporary " means that every project has a definite beginning and a definite end. The end is reached when the project's ob...

Assignment Lanka Populer Posts ever