Færdiggjort

write single line advance sql query

I have a table in sql which has 3 column

id , name and value .

I want to show list of column order by priority in desc order

like "select * from priority where priority>1 order by priority desc "

but when priority having same value then set it to order by rand() with same value of priority then show list.

I have attached snap of table

Evner: Microsoft Access, Microsoft SQL Server, MySQL, PostgreSQL, SQL

Se mere: sql comment syntax, access sql comment, sql comment postgres, sql comment shortcut, sql subquery example, subquery in sql w3schools, sql injection comment, sql server comment, Write some Sql Query, line graph month sql query, write sql query oracle, write oracle sql query oracle 10g, write sql query joins tables example database uses, write sql query oracle 10g, write sql query label column employee title, write sql query will show senior consultants, sql query tree table, write sql query parent child relation tables database, write sql query display employee, write sql query display day system

Om arbejdsgiveren:
( 25 bedømmelser ) Hazaribagh, India

Projekt ID: #15330693

Tildelt til:

nikunjv9

i will complete your project within time-limit. Relevant Skills and Experience i will complete your project within time-limit. Proposed Milestones ₹950 INR - i will complete your project within time-limit. i will co Flere

₹950 INR på 1 dag
(5 bedømmelser)
2.0

8 freelancere byder i gennemsnit ₹1138 på dette job

₹1750 INR på 1 dag
(29 bedømmelser)
6.0
GloblSolutions

Hi let me check please Relevant Skills and Experience skilled Proposed Milestones ₹700 INR - Milestone

₹700 INR på 1 dag
(7 bedømmelser)
4.2
QASIM7862001

A proposal has not yet been provided

₹1250 INR på 1 dag
(5 bedømmelser)
3.9
₹1300 INR på 1 dag
(0 bedømmelser)
0.0
₹1550 INR på 1 dag
(0 bedømmelser)
0.0
itsmeashutosh43

I am a computer engineer who have done many database project. Biiding low for both of our convienience. Hope you consider me. Relevant Skills and Experience I have done database projects for so many years so I think I Flere

₹750 INR på 1 dag
(0 bedømmelser)
0.0
khalidalami

i can do it Relevant Skills and Experience i have the skills Proposed Milestones ₹850 INR - complete your work

₹850 INR på 1 dag
(0 bedømmelser)
0.0