MySQL Tutorial in tamil | How to get middle records in mysql | Select ascending and descending order

Mysql tutorial in tamil for beginners | How to get middle records in mysql query | How to select ascending and descending order in mysql tamil | How to get count of a column | How to filter the records in mysql query in tamil
How to get first 10 records in mysql query tamil

Select particular column:
You should mention whichever columns want to display in your select statement.
Eg: SELECT col1,col2,col3,...etc FROM table_name;

Filter records:
If you want to filter records then you should give where clause and then give your condition.

LIMIT:
If you wan to select first n number of records you should use LIMIT keyword after all the condition of the statement.
Suppose that if you wan to select middle records then you should use limit with starting and count of records.
Eg:
SELECT * FROM city where countrycode='IND' LIMIT (20,10);
here 20 means starting position and 10 means number of records.

ORDER BY ASC or DESC:
If you use ORDER BY ASC keyword in mysql query it will give the result as ascending order.
You should give the ascending order by COLUMN_NAME

ASC Eg:
SELECT * FROM table_name WHERE your_conditon ORDER BY column_name ASC LIMIT 100;

DESC Eg:
SELECT * FROM table_name WHERE your_conditon ORDER BY column_name DESC LIMIT 100;

If you want to find count of particular column you can use count() function in the select statement.

If you want to give alias name you could use "as" keyword

Level-0 :
Level-1 :
Level-2:
Level-3 :
Level-4:
Level-5:
Level-6:
Level-7:

[chandrur]

super bro thanks for contacting this video and please put the videos based on DATE functions